I am trying to add a start date as calculated field , I want it to be 01/07/2021. in dd/mm/yyyy format. I want then to use this date to calculate how many days have passed till date.
I am using function Date(01/07/2021), but it is throwing some random dates in the data set.
6 respostas
@nitin Pal Singh
Hi, in this case, you can use:
DATE(⌗2021-07-01#)
If this post resolves the question, would you be so kind to "Select as Best"?. This will help other users find the same answer/resolution and help community keep track of answered questions. Thank you.
Regards,
Diego
Tableau Ambassador