Expiry Date Notification

[Windsor302]

Hey guys, I have a table for qualifications, there is a column with expiry date. I was wondering what criteria to use in a query that would show only those qualifications expiring within 30 days. Thanks a lot.

 

[rodmc]

Create a query with the Expiry Date, then create a date expression in the criteria row such as =Date() +30 which will include all dates that are 30+ of the current date
I think that should work

 

[rodmc]

sorry that was misleading what I said, what I meant was it will include 30 days after the current date and not 30+ days

 

[Windsor302]

in the criteria I have entered =Date()+30, when I run the query it is blank.

 

[rodmc]

ooops, try puttin this in the criteria of your expiry date column

<=Now()+30

 

[Windsor302]

hmm, I am getting dates within 30 days, but also from a year ago? not sure whats going on

 

[rodmc]

Im an idiot what Ive done there is return everything before the specified date, apologies its been a while since I used a trigger type date function

 

[rodmc]

Ive got this expression in another database to flag up when staff require their mandatory training every year, so that at 30 days prior the query pulls in those records. My heads like swiss cheese Im afraid. I'll get it and get back to you asap

 

[Windsor302]

Oh, no problem. Thanks for your help and theres no rush.

 

[rodmc]

Hi Windsor

I checked the query Ive done previously for the same type of query and in the WHERE statement Ive got:

WHERE [DateField] <date() +30;

This seem to be working for me in my system, so Ive no idea why it isnt working for you, maybe one of our more experienced forum goers can spot where Im going wrong here

 

[Windsor302]

hmm, not sure it is still taking dates from all over, it has almost cut the list in half though

 

[Windsor302]

Got it! Thanks for your help, the syntax I used is: <Now()+30 And >Now()