help in Changing Date format

[Anonymous]

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

[MK_QSL · Accepted solution]

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]

Write like

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

Or

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

[Anonymous]

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

[MK_QSL]

Please close the thread by selection appropriate answer.