Date Formats

[#1]

Can we can set date formats in QlikView?  Our Australian customers would like their reports to show the yyyy/dd/mm format.  We are under the impression date format is configurable by document. 

[shane_spencer]

Yes you can. The following line in the start of your load script sets format:

i.e.

SET DateFormat='DD/MM/YYYY';

You can also over-ride this at a field level.

[Gysbert_Wassenaar]

That's correct. You can set the default date format in the script: SET DateFormat='YYYY/DD/MM';

[maxgro]

at the start of the script you find some default you can modify

example

SET DateFormat='DD/MM/YYYY';

this is at the document level

at the statement level you can use the date function to override the document default

date(field, format)

date(field, 'YYYY/MM/DD')

detail here

QlikView Date fields