converting a date string to a date field
converting a date string to a date field
(OP)
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?
Any ideas?
RE: converting a date string to a date field
cdate({table.field})
or
cdate(val(mid({table.field},7,2)),val(mid({table.field},7,2)),val(left({table.field},2)))
-k