Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

vikasmahajan
Honored Contributor III

HOW TO FORMAT DATE IN QVD

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.

3 Replies

HOW TO FORMAT DATE IN QVD

Hi,

     Use in load script as

     Load

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

     ..From..DataFile

Hope it helps

Celambarasan

MVP
MVP

HOW TO FORMAT DATE IN QVD

Hi,

Use the following load script

LOAD

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

     '

     '

     '

FROM DataSource;

Hope this helps you.

Regards,

Jagan.

vikasmahajan
Honored Contributor III

HOW TO FORMAT DATE IN QVD

Hi

Thanks for reply

Resolved with

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

Community Browser