How can I convert from a date stored in as a string with the format 'DDMMYYYY' to a date of the format 'DD/MM/YYYY'
for example convert the string '22OCT1972' to the date '22/10/1972'
CTOD() only expects the date to be in the format 'dd/mm/yyyy' or 'mm/dd/yyyy', etc
TIA
Start Free Trial