query on dates

[Former Member]

Hi all

i have created a table with two fields i.e "start date" and "alert before start date" , now i want trigger an alert fetching the date from "start date" exactly before the no. of days in "alert before start days".

can anyone suggest me an appropriate query which can be attached to an alert and solve my purpose.

[Former Member · Accepted solution]

Hi Rahul,

What you can try is work with the following function to accomplish what you want:

if DateAdd(Day, MyDaysColumn * -1, GetDate()) then

or maybe you can even include this statement in the where clause of your query

Hope it helps,

Adele