Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Turn yeardaynumber into date

How can I turn a yeardaynumber into a date eg

12001 --> 01-01-2012 or

12282 --> 08-10-2012

Thanks!

1 Solution

Accepted Solutions
Gysbert_Wassenaar

makedate(left(YearDayNumber,2)+2000,1,1) + Right(YearDayNumber,3) -1  as MyDate


talk is cheap, supply exceeds demand

View solution in original post

1 Reply
Gysbert_Wassenaar

makedate(left(YearDayNumber,2)+2000,1,1) + Right(YearDayNumber,3) -1  as MyDate


talk is cheap, supply exceeds demand