Date Issue

[Guest]

I have inherited a database where the dates have been entered as text in the
following format 2005/04/30. I am trying to create a query to select records
within a data range but am having difficulty because of the /'s. Any
suggestions would be appreciated.

 

[Guest]

Try the CDate function to convert them to a date.

-Tony

 

[John Vinson]

I have inherited a database where the dates have been entered as text in the
following format 2005/04/30. I am trying to create a query to select records
within a data range but am having difficulty because of the /'s. Any
suggestions would be appreciated.

Try creating a calculated field:

SearchDate: CDate([textdate])

This will be a Date/Time field and will be searchable with normal date
criteria such as

BETWEEN Date() AND DateAdd("m", 3, Date())

John W. Vinson[MVP]