This content has been marked as final. Show 3 replies
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,