Have you tried to change format of your date from left window pane by right clicking date field, Default Properties, Date Format and choose format you want.
Yes, tried that but unsuccessful...
Sent from my iPhone
1 of 1 people found this helpful
Default formatting doesn't 'survive' a calculated field. So when you convert the date into a string you get the format that Tableau uses to store the date. If you really can't live with that formatting then you'll need to break it down into month, day, year:
str(MONTH([Start Date Weekending])) + '/' + STR( DAY([Start Date Weekending]) ) + '/' STR( YEAR([Start Date Weekending]) )
Lot of extra work.
Thanks Shawn! works great!