Date format

[#1]

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.

[beck_bakytbek]

Hi Ana,

Try this:

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

or

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

Beck

[#3]

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.

[Miguel_Angel_Baeyens · Accepted solution]

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

[#5]

It was what I thought but wanted to confirm.

Thanks a lot!