topic Date format Issue in QlikView

Date format Issue

Mon, 21 Dec 2009 23:28:13 GMT

Hello,

I receive a date with that format (YYYYDDD) where DDD is the number of the day of the year.

(002 meaning 02 January, 032 meaning 01 february).

Is there any way I can create a "Real Date" with a format like YYYY/MM/DD ?

Thanks for your help.

Philippe

Mon, 21 Dec 2009 23:36:28 GMT

Something like:

=Date(MakeDate(YYYY) + DDD)

That will take the number of days added to January 1st of the year, to get the date.

Mon, 21 Dec 2009 23:52:16 GMT

Try this:

Date(MakeDate(left(Date, 4))+(right(Date, 3))) as RealDate

Tue, 22 Dec 2009 00:11:07 GMT

Thanks a lot !!!!

Philippe