Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
date(date#('1-Aug-12','D-MMM-YY'), 'DD-MM-YYYY')
date(date#('1-Aug-12','D-MMM-YY'), 'DD-MM-YYYY')
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