Hi,
I am using pre-populated data set and using a date that I want to calculate with current date i.e.today().
The pre-populated data set is in .csv format and date is in 'YYYY-MM-DD'. When I read from the pre-populated and display on the screen, I can see the correct display of the value, e.g. '2011-11-25'. I assume the date values are in text format which we need to convert to 'date' format.
I have used the command date(${field1}) to convert to date format and when the output it shows a blank field.
Can anyone suggest how to convert to date from a text.
Many thanks,