date formatting

[hishopper]

My data ultimately comes from a .csf file (linked table) that is exported from an Oracle database - however due to the quirky front end of the Oracle db (anyone ever heard of Remedy?) the date format is strictly text (I can't set the fieldtype to date becuase "createdate
05/31/2002 5:01:08 PM" isn't valid.

However, somehow I need to calculate the timediff between the above string and now() or between two of the strings...

Any suggestions?

 

[Pat Hartman]

If all the dates are prefixed by "createdate ", you can strip the leading characters off leaving a valid date.

CDate(Mid(YourDate,12))