converting a date string to a date field

quesnell · Dec 30, 2003

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 · Dec 30, 2003

Try:

cdate({table.field})

or

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

-k

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

converting a date string to a date field

quesnell

Technical User

synapsevampire

Programmer

Similar threads

Part and Inventory Search

Sponsor