Qlik Community

Ask a Question

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
Talk to Experts Tuesday, January 26th at 10AM EST: Qlik Sense. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Champion
Champion

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

Hi,

     Use in load script as

     Load

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

     ..From..DataFile

Hope it helps

Celambarasan

MVP & Luminary
MVP & Luminary

Hi,

Use the following load script

LOAD

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

     '

     '

     '

FROM DataSource;

Hope this helps you.

Regards,

Jagan.

Champion
Champion

Hi

Thanks for reply

Resolved with

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