Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

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

Re: Turn yeardaynumber into date

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


talk is cheap, supply exceeds demand
1 Reply

Re: Turn yeardaynumber into date

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


talk is cheap, supply exceeds demand
Community Browser