HOW TO FORMAT DATE IN QVD

[vikasmahajan]

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]

Hi,

     Use in load script as

     Load

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

     ..From..DataFile

Hope it helps

Celambarasan

[jagan]

Hi,

Use the following load script

LOAD

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

     '

     '

     '

FROM DataSource;

Hope this helps you.

Regards,

Jagan.

[vikasmahajan]

Hi

Thanks for reply

Resolved with

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