topic Re: Date format in QlikView

Date format

Mon, 19 Jan 2015 15:42:15 GMT

Hi all,

Although I have defined a date format on the beginning of the script with: "SET DateFormat='YYYY-MM-DD';", when I load data fields from a QVD file they appear with the QVD format instead of what was defined in DateFormat.

SET DateFormat doesn't format the QVD data?

Thanks in advance for your help.

Re: Date format

beck_bakytbek — Mon, 19 Jan 2015 15:50:57 GMT

Hi Ana,

Try this:

Date(Date, 'DD/MM/YYYY') as Date,

Date(Date(YourDate,'DD/MM/YYYY'), 'DD-MM-YY') as yourDate

Beck

Re: Date format

Mon, 19 Jan 2015 16:02:05 GMT

Ok. I know that I can format the dates during the load.

I just wanted to know to what kind of dates the Set DateFormat applies to.

Does anyone know?

Thanks.

Re: Date format

Miguel_Angel_Baeyens — Mon, 19 Jan 2015 16:05:10 GMT

Hi Ana,

It specifies the format of the dates instead of using the one already specified by the OS. It applies to whenever the Date() function is called, either it be in the script or UI.

If the value passed to the function is not recognized as a date, then it will be shown in its original format.

Miguel

Re: Date format

Mon, 19 Jan 2015 16:08:29 GMT

It was what I thought but wanted to confirm.

Thanks a lot!