convert text to dates

  • Thread starter Thread starter Sandra
  • Start date Start date
S

Sandra

I'm using Access for reporting on data in another
database. I'm trying to create parameter reports based on
the call enter date. In the source database, this field
is a text field. I need to be able to convert it to a
date/time data type. Anyone have any suggestions?

Thanks.
 
Try a query that looks like this:
Field in which Date is Text: MyDate
Expr1: DateValue([MyDate])

Roxie Aho
 
Back
Top