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!