2 Replies Latest reply on Feb 7, 2019 5:39 AM by sajad.bhat

Dates between two dates

shanmuga prabhu Feb 7, 2019 2:13 AM

Hi All

Please let me how to get All Dates between start date and end date

Example

Start Date End Date

Jan 2018 Feb 2018

Result should be

01/ jan /2018

02/jan/2018

...

31/feb/2018

thanks

1. Re: Dates between two dates

Jim Dehner Feb 7, 2019 4:40 AM (in response to shanmuga prabhu)

Archana Ganeshalingam and Sasha Singh tackled this and other time based problem at TC 18

see the link Solving tough time-based problems with skeleton tables and Tableau Prep - YouTube

Jim
Like Show 0 Likes(0)

Actions
2. Re: Dates between two dates

sajad.bhat Feb 7, 2019 5:39 AM (in response to shanmuga prabhu)

Hi Shanmuga,

the difference in dates you can find in below calc with two parameters, date1&date2.
IF [Order Date]>=[Date1] AND [Order Date]<=[Date2]
THEN [Order Date] END
Hope it helps.
Like Show 0 Likes(0)

Actions

Tableau Community Forums