Date conversion issue

[_armoco_]

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

[kaushiknsolanki · Accepted solution]

Try this.

LOAD [Sr. No],

     //Date,

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

     Attendance

FROM

Data.qvd

(qvd);

Regards,

Kaushik Solanki

[hemeshreddy]

try with

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

Regards,

Hemesh

[devarasu07]

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);

[_armoco_]

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

[devarasu07]

Hi,

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