dates in script load

Thu, 27 Oct 2011 12:02:29 GMT

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 — Thu, 27 Oct 2011 15:15:55 GMT

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

topic dates in script load in QlikView