Date formats

[reshma_km]

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

[sunny_talwar · Accepted solution]

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

[reshma_km]

Hi,

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

[sunny_talwar]

Yes that's what I mean