Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

surender7
New Contributor

help in Changing Date format

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

1 Solution

Accepted Solutions

Re: help in Changing Date format

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.

4 Replies

Re: help in Changing Date format

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.

Re: help in Changing Date format

Write like

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


Or


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

surender7
New Contributor

Re: help in Changing Date format

Thanks a lot, Manish and Anand, it workedSmiley Happy

Re: help in Changing Date format

Please close the thread by selection appropriate answer.

Community Browser