3 Replies Latest reply on Nov 25, 2018 11:31 AM by Joshua Milligan

Dateadd produces datetime not date, any way to create date only?

Christine___ Nov 25, 2018 2:37 AM

this code

DATEADD('month',2,[End Date])

produces a field that is formatted as datetime despite [End Date] being date only. I then have to manually go and change the variable and I would prefer to create a date only variable in one step.

Is there a different code for when I just want to create a date variable?

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___)

Wrap it inside the Date() function.
1 of 1 people found this helpful
Like Show 1 Likes(1)

Actions
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___)

Hi
As already suggested by Ombir.
you can use:DATE(DATEADD('month',2,[End Date])) it should work.
1 of 1 people found this helpful
Like Show 1 Likes(1)

Actions
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___)

Hi 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
1 of 1 people found this helpful
Like Show 0 Likes(0)

Actions

Go to original post

Tableau Community Forums

Dateadd produces datetime not date, any way to create date only?

1. Re: Dateadd produces datetime not date, any way to create date only?

2. Re: Dateadd produces datetime not date, any way to create date only?

3. Re: Dateadd produces datetime not date, any way to create date only?

Sign In or
Create your Account

Actions

More Like This

Sign In or Create your Account

Sign In or
Create your Account