Due date

[tmarsh]

I'm trying to base a report on a query that will pick up records with a review date within a year, that is, within the next year from today's date. I have a date of assessment field in a table and I use a calculated control on a form to see the due date (date of assessment + 1 year) in whatever record I'm looking at. I want to run a query that will pick up all due dates within 1 year.

Tricky to explain this! This is what I've put in my query:

Expr1: IIf([RA_DATE] Is Not Null,DateSerial(Year([RA_DATE]),Month([RA_DATE])+12,Day([RA_DATE])),"")

This gives a date a year in advance. How do I reference that from todays date so each time I run the query it returns only assessments due from today until due date?

 

[Galaxiom]

WHERE datefield BETWEEN Date() AND DateAdd("yyyy", 1, Date())

 

[tmarsh]

WHERE datefield BETWEEN Date() AND DateAdd("yyyy", 1, Date())

That's done the trick. Thanks very much.