This content has been marked as final.
Show 3 replies
-
1. Re: Dateadd produces datetime not date, any way to create date only?
Ombir Rathee Nov 25, 2018 6:55 AM (in response to Christine___)1 of 1 people found this helpfulWrap it inside the Date() function.
-
2. Re: Dateadd produces datetime not date, any way to create date only?
MV V Nov 25, 2018 9:32 AM (in response to Christine___)1 of 1 people found this helpfulHi
As already suggested by Ombir.
you can use:DATE(DATEADD('month',2,[End Date])) it should work.
-
3. Re: Dateadd produces datetime not date, any way to create date only?
Joshua Milligan Nov 25, 2018 11:31 AM (in response to Christine___)1 of 1 people found this helpfulHi Christine,
In addition to explicitly casting to a date using the DATE() function as suggested by both Ombir and MV, you can also simply change the data type of the calculated field to Date in Tableau Prep and newer versions of Tableau Desktop.
Best Regards,
Joshua