Expiry Date Warning

[Abbosy]

Hi there Forum

Can a Form/Query warn when a date is approaching; like in a pop up or any other behaviour?

Many thanks

 

[jdraw]

You can calculate how many days since or before date X, then display a message as appropriate.

More info is required to give a more specific answer.

 

[pr2-eugin]

Yes what you need is quiet possible.. More information will help us to help you in the correct way..

EDIT: JD and I are 'peas in a pod'

 

[Abbosy]

Thanks jdraw & Paul
I set up a record to add "wanranty expiry date". I just need a reminder to pop up telling us that this customer has his warranty about to run out so we can approach the customer with a reminder.

Many Thanks

 

[Abbosy]

Hi again jdraw & Paul
The warranty is a date/time field. If this is helping to know.
Many Thanks

 

[pr2-eugin]

Is warranty expiry date calculated/depended on other fields in the table?

 

[Abbosy]

Hi Paul

Thanks for your swift reply

Yes it is calculated from a number "number of years warranty taken" * 365 + Date()

 

[pr2-eugin]

Okay delete the field in the table, and move the calculation to a Query. Then use that as the criteria to filter. Something like.

SELECT someFields, ((noOfYears * 365) + startDate) As expiryDate 
WHERE ((noOfYears * 365) + startDate) = Date();

The above Query will give everything that is expiring today.