Today's date less one year query (1 Viewer)

[mkdrep]

I have a number of quotations that I would like to follow up on and I want to base it on all quotations from the date the query is run, going back one year. I know I can manually set the query up to input a date range, but I'd like the query to run and automatically go back one year.

For example, the field I am using is [JobBidDate] and I would like the query to run and include a jobs with a [JobBidDate] of today's default date and going back (352) days.

Any suggestions.

 

[MarkK]

Being the WHERE clause in your query . . .

WHERE JobBidDate >= Date() - 352

 

[arnelgp]

Where [JobBidDate] Between DateAdd("yyyy",-1,Date()) And Date()

 

[mkdrep]

Being the WHERE clause in your query . . .

WHERE JobBidDate >= Date() - 352

Thank you very much! That did it