Skip to main content

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 answers
  1. Feb 17, 2022, 1:06 PM

    @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