Date in query

[mcraven]

I need to create a report where the termination date will be within 30 days of today's date (whatever day that is). In the query I have >=Now()-30 and I realize why I'm getting everything after today's date, not just the ones within 30 days, but when I try taking out the >, I get nothing. Can anyone help?

 

[Brianwarnock]

You need
Between Date() And DateAdd("d",30,Date())

use Date() not Now() if only adate and not time required.

Brian

 

[mcraven]

Date in Query

thank you - it worked!!!