converting a date string to a date field

[quesnell]

I have been trying to convert a date string to a date field using the DTSTodate function but the field comes up blank. I have set the report options to show date fields as just date but have still not had any luck. I have not experienced this problem before. The string field currently holds the date in the format of 30/12/2003.

Any ideas?

 

[synapsevampire]

Try:

cdate({table.field})

or

cdate(val(mid({table.field},7,2)),val(mid({table.field},7,2)),val(left({table.field},2)))

-k