How to convert to a date format from the sample

[#1]

HI,

Kindly look @ sample.xls and let me know to convert the same into date

regards

venkat

[sivarajs · Accepted solution]

Try this

date(date#('Fieldname','DD-MMM-YY hh.mm.ss[.fff]'),'DD/MM/YYYY hh.mm.ss')