Selecting week of records from this weeks date

[cclambie]

Hi,

I am trying, and getting nowhere...so would appreciate your help... to create a query where records with dates from 8 weeks, or two months ahead appear in the query.

That is I have contracts ending in two months in my table and I want to run a query on who I should call now to renew contracts.

I have a contract end date in table.

I have tried
>=DateAdd("m",2,Now())<=DateAdd("m",2,Now())
only to get all sorts?

>=DateAdd("d",60,Now())<=DateAdd("d",68,Now())
only to get all sorts of things appearing?

Anyone that could help would be great.
I have contact info in a TBLCONTACTS and linked to TBLMOBILES via COMPANY_ID

Thanks heaps!

C

 

[ThreeCrow]

Try this

DateSerial(Year(Date), Month(Date) + 60, 1)

If todays date is 7-1-05 dates shown will be 9-1-05

Hope this helps

 

[Rich]

>=DateAdd("m",2,Date())