Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

help in Changing Date format

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

1 Solution

Accepted Solutions
MK_QSL
MVP
MVP

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.

View solution in original post

4 Replies
MK_QSL
MVP
MVP

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
Not applicable
Author

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

MK_QSL
MVP
MVP

Please close the thread by selection appropriate answer.