4 Replies Latest reply on Sep 24, 2014 2:47 AM by Andreas Fischer

    Calculate monday of current week

    Andreas Fischer

      Hi everyone,


      I am trying to calculate the date of monday in the current week using a Tableau Calculated Field. So obviously the result of the calculation will change everytime a new week starts.



      I can easily do this in MSSQL like this:

           DATEADD(ss, 43200, DATEADD(wk, DATEDIFF(wk,0,GETDATE()), 0)) AS MondayOfCurrentWeek



      However I would like to do it in Tableau instead. Is this manageable?


      Thank you for your help!