0
votes

I have a Tableau worksheet where one of the fields is a date field with format MDY(e.g August 30, 2020). I am trying to change its format to MM/DD/YYYY( e.g. 08/30/2020)

According to the documentation, I should be able to change the format by right clicking the date field in the view section and selecting the format option.

However, when I do the above, I only see 'Null' in the format option (See screenshot below) screenshot of format options for the date field I am not sure why the option would be unavailable here, can someone help me out here please?

1
Does Tableau think your date is a date?Andy TAR Sols

1 Answers

0
votes

Your date is actually a date part. Change to the Day per below then set to discrete.

enter image description here

enter image description here

Now format as desired.

enter image description here