5 Replies Latest reply: Aug 28, 2016 7:35 PM by Rupam Das RSS

    Transforming a data into a weeknumber

    Marc van der Peet

      Dear all,

       

      I have a column called "OFF_SWITCH_DAT" with date that looks like this: DD-MM-YYYY HH:MM:SS (like this: 4-1-2016 17:48:50). What I would like to do now is transform this value into a weeknumber.

       

      I have tried this:

      WeekName((OFF_SWITCH_DAT),'-') as WeekNum,

      But this gives me the following output:

       

      -

       

      Also

       

      WeekName(OFF_SWITCH_DAT) as WeekNum,

      Does not work (giving me 2016/04)

       

      Any thougts on how I can get a weeknumber.



      Cheers,

       

      Marc