Conditional event based on a date

[mckay1402]

Hi

I have created a tenders table with a contract end date and I want some sort of notification or email when the contract end date is coming up. I have no idea what I'm doing can anyone help?


thanks

 

[Ranman256]

create a query that uses the end date.
This pulls recs where date within 1 week of end date

select * from tTenders where datediff("d",[ContractEndDate],date())>8

 

[mckay1402]

create a query that uses the end date.
This pulls recs where date within 1 week of end date

select * from tTenders where datediff("d",[ContractEndDate],date())>8

Thank you. I have created a query that pulls the contract end dates in ascending order. Ideally I would like it to do that when the contract end date is 30 days away so we can prepare to start looking out for it...I have also set a macro to run the query but I can't work out how to phrase the condition. I guess you have answered that...I'll let you know.

 

[Ranman256]

just change the 8 to a 30.

 

[vbaInet]

There's a slight typo in Ranman256's post re DateDiff(). Use the following link to correct it:

http://www.techonthenet.com/access/functions/date/datediff.php