DATE function, need help

[#1]

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.

[swuehl · Accepted solution]

Maybe

DATE(DATE#(FIELD,'DD-MMM-YYYY'),'DD/MM/YYYY')

or

DATE(DATE#(left(FIELD,11),'DD-MMM-YYYY'),'DD/MM/YYYY')

[#3]

ha, i think, i got to work on year as i am getting only last 2 digits!

[#4]

Hi Swuehl,

yes, your first suggestion did the trick.

thanks a lot for ur quick reply & help.

[swuehl]

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'?).