dates in script load

[#1]

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

[erichshiino]

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