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!