Date conversion

[#1]

Hi,

How to convert this text values of date into correct date values like 1-Aug-12 and

1-Aug-12 this to be conerted into

01-08-2012

Thanks

[Anonymous · Accepted solution]

date(date#('1-Aug-12','D-MMM-YY'), 'DD-MM-YYYY')

[jonathandienst]

Hi

Assuming that '1-Aug-12' is a text field in your data source, then this should do it (just change the fieldname InputDate to the correct field name containing the 1-Aug-12 date string):

Date(Date#(InputDate, 'D-MMM-YY'), 'DD-MM-YYYY')

Regards

Jonathan