4 Replies Latest reply on Jun 11, 2018 7:44 AM by Bryce Larsen

    Convert integers to date

    Marc-Antoine Provost

      Hi,

       

      I have multiple integers which I would like to convert to Dates.

       

      I.e :

      Week_num
      Date (desired column)
      101/01/2018
      201/08/2018
      ......

       

      My integers consist of numbers from 1 to 20, corresponding to week numbers in 2018.

       

      I tried the following in a calculated field :

       

      IF [WEEK_NUM]=1 THEN MAKEDATE(2018,01,01)

      ELSEIF [WEEK_NUM]=2 THEN MAKEDATE(2018,01,15)

      ELSEIF

      ...

      END

       

      Thank you very much !