Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

how to set the alert

Hi All,

Based on the below criteria i want to set the alert

Select U_SDate,U_EDate from [@PROJ_DET]
=====================================

U_Sdate             U_Edate
-------------            -------------
1)2008-10-01       2008-11-01
2)2008-10-02       2008-12-25

so, in the first row the project planned is 30 days..so i want to set a alert like if the current date comes to 2008-10-10(i,e before 20 days)....i should show a alert....can anybody suggest me some ideas like how to set these alert before completion of the project before 20days of U_Edate.

regards,

shangai.

Not what you were looking for? View more on this topic or Ask a question