How to convert alphanumeric field into date field

[#1]

How to convert  a alphanumeric field  (Ex:01JAN2010) into a date field as 01/01/2010?

[Gysbert_Wassenaar · Accepted solution]

date(date#('01JAN2010','DDMMMYYYY'),'DD/MM/YYYY')