Date Issue

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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.
Click to expand...

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]
 
Back
Top