How to change yymmdd to mmddyy ?

[#1]

Hi ,

I'm new to qlikview ,I have data (date field in year-month-day format I want to convert it into month,day year format ?

Regards

Malikarjun

[swarup_malli · Accepted solution]

this should do

   date(YourDateField,'MM/DD/YYYY') as DATE,

Regards

Swarup

[#3]

Hey that was fast, let me try it..

Thank u Swarup