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

[#1]

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

[#2]

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

=DATE(38720)

[#3]

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

[#4]

OK I got it, by simple:

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

Thank you for your help!

[#5]

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

[#6]

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......