Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Partner
Partner

Date conversion issue

Hi all,

Unable to convert date to MM/DD/YYYY format. Tried with date# and then date and for some reason its not working out.

What am I missing?

Please find the attached QVD.

Thanks and Regards,

Arjun

1 Solution

Accepted Solutions

Re: Date conversion issue

Try this.

LOAD [Sr. No],

     //Date,

     Date(Date#(Date,'D-MMM-YY')) as Date,

     Attendance

FROM

Data.qvd

(qvd);

Regards,

Kaushik Solanki

5 Replies

Re: Date conversion issue

Try this.

LOAD [Sr. No],

     //Date,

     Date(Date#(Date,'D-MMM-YY')) as Date,

     Attendance

FROM

Data.qvd

(qvd);

Regards,

Kaushik Solanki

Partner
Partner

Re: Date conversion issue

try with

Date(Date#(Date,'DD-MMM-YYYY'),'DD-MM-YYYY') as Date

Regards,

Hemesh

Highlighted
devarasu07
Honored Contributor II

Re: Date conversion issue

Hi,

you can try like below,

load *, Date(Date#(Date,'DD-MMM-YYYY'),'DD/MM/YYYY') as NewDate;

LOAD [Sr. No],

     Date,

     Attendance

FROM

(qvd);

Capture.JPG

Partner
Partner

Re: Date conversion issue

Woah! I missed out MMM and was trying with MM. Thanks guys!

devarasu07
Honored Contributor II

Re: Date conversion issue

Hi,

Fine, can you close this thread by marking helpful and correct for the replies.  Thanks