topic Re: help in Changing Date format in QlikView

help in Changing Date format

Anonymous — Mon, 26 Jan 2026 18:19:17 GMT

How can we change the date format from Feb 20, 2014 to 02/20/2014

MK_QSL — Mon, 28 Apr 2014 15:54:52 GMT

Date(Date#('Feb 20, 2014','MMM DD, YYYY'),'DD/MM/YYYY')

Date(Date#(YourDateField,'MMM DD, YYYY'),'DD/MM/YYYY') as Date

Sorry, Above will give you in DD/MM/YYYY format...

For MM/DD/YYYY change accordingly....

Thanks Anand.

its_anandrjs — Mon, 28 Apr 2014 16:05:54 GMT

Write like

Date(Date#('Feb 20, 2014','MMM DD, YYYY'),'MM/DD/YYYY')

Date(Date#(YourDateField' , 'MMM DD, YYYY'),'MM/DD/YYYY')

Anonymous — Mon, 28 Apr 2014 16:29:58 GMT

Thanks a lot, Manish and Anand, it worked:)

MK_QSL — Mon, 28 Apr 2014 16:35:14 GMT

Please close the thread by selection appropriate answer.