topic HOW TO FORMAT DATE IN QVD in QlikView

HOW TO FORMAT DATE IN QVD

vikasmahajan — Fri, 17 Feb 2012 09:40:54 GMT

Dear All,

Find attachment of qv file I want to load data from xlsx file but the date field

I am getting number's I want this date in "DD/MM/YYYY" format in my qvw file.

CELAMBARASAN — Fri, 17 Feb 2012 09:46:37 GMT

Hi,

Use in load script as

Load

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

..From..DataFile

Hope it helps

Celambarasan

jagan — Fri, 17 Feb 2012 10:40:08 GMT

Hi,

Use the following load script

LOAD

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

FROM DataSource;

Hope this helps you.

Regards,

Jagan.

vikasmahajan — Fri, 17 Feb 2012 11:25:37 GMT

Thanks for reply

Resolved with

Date (Num(Evaluate(DATE) )) as Date