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

    Transforming a data into a weeknumber

      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:






      WeekName(OFF_SWITCH_DAT) as WeekNum,

      Does not work (giving me 2016/04)


      Any thougts on how I can get a weeknumber.