querying with text/dates

[ckitzman]

I'm trying to make changes to records that are 3 years old. The date format is text and it displays as Ex. "20020831" or yyyymmdd.

i try <"20020101" but I get no results and I know there should be.
I'm a rookie and only know how to query using short date format.

ideas anyone?
thx

 

[mhartman]

Hello:

You need to enclosed your date between the # characters, as in #10-01-2006#

Regards
Mark