topic Date Formats in QlikView

Date Formats

Mon, 23 Jun 2014 14:50:04 GMT

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.

Re: Date Formats

shane_spencer — Mon, 23 Jun 2014 14:52:38 GMT

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.

Re: Date Formats

Gysbert_Wassenaar — Mon, 23 Jun 2014 14:53:18 GMT

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

Re: Date Formats

maxgro — Mon, 23 Jun 2014 14:56:53 GMT

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