3 Replies Latest reply: Aug 14, 2015 8:55 AM by Peter Svendsen RSS

    How to convert a week number to a weeknumber

    Peter Svendsen

      Hi,

       

      I have a xls file that contain a weeknumber e.g. 32 but when I load the data it is presented as 1, 2, 3.... upto 8.

      So I assume that I need to convert the week to a weeknumber, what I have done is:

       

      Week(Week of expected work) as WeekExpectedTask,

       

      If I dont use anything it will change the week to a data in 1900.....

      So none of the solutions work, what is wrong with this and why?

       

      Thanks in advance,

      Peter