Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How to convert a alphanumeric field (Ex:01JAN2010) into a date field as 01/01/2010?
date(date#('01JAN2010','DDMMMYYYY'),'DD/MM/YYYY')
date(date#('01JAN2010','DDMMMYYYY'),'DD/MM/YYYY')