7 Replies Latest reply: Jun 18, 2014 10:01 AM by Günter Angerer RSS

    Convert week number and year to a standard date

    Günter Angerer

      I'm struggling with a date format that I would like to convert...

       

      The format that I have from the data source is like this: 05WO05

      05 = week number

      WO = the abbreviation for "week" in german

      05 = the year, i.e. 2005 (data goes back to 1993!)

       

      My goal is a format that will enable to me to have the data sorted by month and calendar year.

       

      Any idea?

       

      Many thanks for your help!

       

      Regards

      Günter