topic Re: Date formats in QlikView

Date formats

reshma_km — Wed, 21 Oct 2015 10:12:55 GMT

Hi,

Suppose I load a table with a date field formatted like D-MMM-YY.

But in the configuration tab, Qlikview default is set as SET DateFormat='M/D/YYYY';

Will there be any conflicts due to this in the date values?

And is there any format difference when the date values are displayed in front-end objects? say, when displayed in a straight table and when displayed on a list box, will the date formats be same?

Thanks,

Reshma

Re: Date formats

sunny_talwar — Wed, 21 Oct 2015 15:25:36 GMT

Yes, most likely QlikView won't be able to recognize your date formatted as D-MMM-YY as a date field. You can tell QlikView to understand it as date by doing this:

SET DateFormat = 'M/D/YYYY';

Date#(DateField, 'D-MMM-YY') as DateField

Now to convert it to QlikView's default, you can do this:

Date(Date#(DateField, 'D-MMM-YY')) as DateField

Re: Date formats

reshma_km — Thu, 22 Oct 2015 09:12:17 GMT

Hi,

By Qlikview's default, you mean the format defined by the SET expression?

Re: Date formats

sunny_talwar — Thu, 22 Oct 2015 12:34:25 GMT

Yes that's what I mean