Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I have a Script in a QV document with the Qlikview 9 Server versión, the fields with date type are loading with the format DD/MM/YYYY
in the QlikView 10 Server version , the dates are load with the format YYYY/MM/DD
any idea how to solve this?
Thanks
Hi, jmmartinez.
You can check the following variable in the beggining of your script.
SET DateFormat='D/M/YYYY';
Anyway, you can re-format it on settings -> Document Settings -> number
or use the date () function to format it on an object or expresssion
Date (Date_Field, 'DD/MM/YYYY')
Hope this helps,
Erich