Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Qlikview is also working with the numeric format. To format a date to a normal date notation use:
=DATE(38720)
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
OK I got it, by simple:
date(Datum,'DD/MM/YYYY') as CalendarDate.
Thank you for your help!
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
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......