Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
i am trying to convert date format from DD-MMM-YY(15-Oct-12) into DD/MM/YYYY(15/10/2012)
i tried no. of ways as below:
DATE(DATE#(FIELD),'DD/MM/YYYY')
DATE(DATE#(FIELD,'DD MMM YYYY'),'DD/MM/YYYY')
But, i am getting empty fields only.
any help much appreciated.
Maybe
DATE(DATE#(FIELD,'DD-MMM-YYYY'),'DD/MM/YYYY')
or
DATE(DATE#(left(FIELD,11),'DD-MMM-YYYY'),'DD/MM/YYYY')
Maybe
DATE(DATE#(FIELD,'DD-MMM-YYYY'),'DD/MM/YYYY')
or
DATE(DATE#(left(FIELD,11),'DD-MMM-YYYY'),'DD/MM/YYYY')
ha, i think, i got to work on year as i am getting only last 2 digits!
Hi Swuehl,
yes, your first suggestion did the trick.
thanks a lot for ur quick reply & help.
Ah, sorry, your input format is DD-MMM-YY only two YY digits, right?
DATE(DATE#(FIELD,'DD-MMM-YY'),'DD/MM/YYYY')
or
DATE(DATE#(left(FIELD,11),'DD-MMM-YY'),'DD/MM/YYYY')
Your format code in the date#() function should exactely match your format of your strings.
Check your input values in table view or a list box. Check also, that they are not already interpreted as dates (maybe your standard date format is 'DD-MMM-YY'?).