Membership Expiry Dates

[Guest]

I have read the previous messages posted regarding criteria. I have in fact
used the following criteria:

<=Date()+31

and the criteria works and is bringing up all records prior to that date,
however regardless of the year - for example - it is bringing up dates
15/06/2006. It appears to be taking note of the day and month but not the
year. How do I rectify this problem??

 

[John Vinson]

I have read the previous messages posted regarding criteria. I have in fact
used the following criteria:

<=Date()+31

and the criteria works and is bringing up all records prior to that date,
however regardless of the year - for example - it is bringing up dates
15/06/2006. It appears to be taking note of the day and month but not the
year. How do I rectify this problem??

What is the datatype of the field you're searching - Date/Time, or
Text? Could you open this query in SQL view and post the actual SQL
string?

John W. Vinson[MVP]

 

[Guest]

Thanks for the suggestion John. Having viewed this query in the SQL view I
realised I had made an error in entering criteria in another field.

Many thanks