Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How can we change the date format from Feb 20, 2014 to 02/20/2014
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.
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.
Write like
Date(Date#('Feb 20, 2014','MMM DD, YYYY'),'MM/DD/YYYY')
Or
Date(Date#(YourDateField' , 'MMM DD, YYYY'),'MM/DD/YYYY')
Thanks a lot, Manish and Anand, it worked:)
Please close the thread by selection appropriate answer.