Contract end notification (1 Viewer)

[Scolton]

Hello,

I have a table which contains the primary key, begin date contract and end date contract. Now i want to get a notification (email) when a contract is almost about to end. How can i set this up?

Thanks in advance.

 

[llkhoutx]

"About to end" is not a term of art. query the table to find rows with a contract end date within a given number of days of the current date, i.e. [contract end date]-Now()<=Days (an integer).

 

[Scolton]

Thanks i got it working. Sorry for the late response^^