topic Help needed! How to convert a date from 38720 to 3/01/2006 in QlikView

Help needed! How to convert a date from 38720 to 3/01/2006

Tue, 08 Jun 2010 08:17:31 GMT

Dear Qlik View users,

I need you help once again- in my Excel file date is formatted as a number ex. 38720 and I would like to get date in script out of that. Any suggestions?

Thank you in advance,

Beata

Help needed! How to convert a date from 38720 to 3/01/2006

Tue, 08 Jun 2010 08:22:17 GMT

Qlikview is also working with the numeric format. To format a date to a normal date notation use:

=DATE(38720)

Help needed! How to convert a date from 38720 to 3/01/2006

Tue, 08 Jun 2010 08:31:44 GMT

Dear Sander,

Thank you for a fast reply. As I am still not doing good with a script, it means that I should write:

set Date=date('00000') ? but than where I turn it to the proper format? my main issue is that I want to link date in this format into my Master Calendar.

Thanks in advance,

Beata

Help needed! How to convert a date from 38720 to 3/01/2006

Tue, 08 Jun 2010 08:35:34 GMT

OK I got it, by simple:

date(Datum,'DD/MM/YYYY') as CalendarDate.

Thank you for your help!

Help needed! How to convert a date from 38720 to 3/01/2006

Tue, 08 Jun 2010 09:13:48 GMT

Hello Beata,

Because Qlikview is working with numeric values you could better use a numeric date value for your master calendar. For presentation you could use a formatted field but for calculations in your script a numeric value is the best solution (best performance)! Every Qlikview date function use the numeric format, for example: "month(38720)".

Kind regards,

Sander

Help needed! How to convert a date from 38720 to 3/01/2006

Tue, 08 Jun 2010 09:22:30 GMT

Hi Beciafreestyle,

just check out this post. Hope this will get you into your solution.

http://community.qlik.com/forums/t/29680.aspx

Thanks Joseph......