Date transformation

[#1]

i have the following date format which i wish to transform

1302-4

13 is Year ie . 2013

02 is week example week 2

-4th day of week nr 02

the date here would be 2013-01-10.

i have tried to use the following statement without success.

Makedate(2000+ num(left(Leveranstid,2)), num(week(mid(Leveranstid,3,2))), num(day(right(Leveranstid,2))))

best

Brad

[marcus_sommer]

Try this:

date(num(Makedate(2000+ num(left(Leveranstid,2)))) +

((num(week(mid(Leveranstid,3,2))) * 7) +

num(day(right(Leveranstid,2))))), 'YYYY-MM-DD')

- Marcus

[#3 · Accepted solution]

Try this

makeweekdate(Year(Date#(left('1302-4',2),'YY')), num(mid('1302-4',3,2)),num(right('1302-4',1)))