3 Replies Latest reply on Aug 29, 2016 4:16 AM by Shriram Saxena

    Date conversion

    Dibyendu Sharma Mondal

      Dear All,

       

      I think someone would have already answered somewhere but I am unable to locate exactly what I am looking for.

       

      I just need to have a quick calculation which will convert my date to anything I want, in Excel I use to do this by combination of 3 functions i.e. Date(Year(), Month(), <any day of choice>)

       

      for example I want the 1st date from any date of that month (Field name {Report Date}) then I use the formula : DATE(YEAR({Report Date}), MONTH({Report Date}), 1)

       

      I am trying to replicate the same thing in Tableau, need help