Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Not applicable

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

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

5 Replies
Highlighted
Not applicable

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

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

=DATE(38720)

Highlighted
Not applicable

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

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

Highlighted
Not applicable

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

OK I got it, by simple:

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

Thank you for your help!

Highlighted
Not applicable

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

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

Highlighted
Not applicable

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

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