topic Re: IF Statement with a date condition in Application Development and Automation Discussions

IF Statement with a date condition

former_member518858 — Mon, 07 Mar 2016 13:48:07 GMT

Hi all,

So basically I am wanting to check to see if a table or report is empty and if it is, send a notification email.

Therefore, my current code is IF tablename is initial

CALL FUNCTION 'Z SEND EMAIL'

My question is I want this to check once a day if this report or table is empty. So if the report is empty for the day, send the email.

How do I go about adding the check by date part?

Thanks

Re: IF Statement with a date condition

PeterJonker — Mon, 07 Mar 2016 13:58:09 GMT

schedule your program as a daily job

Re: IF Statement with a date condition

Patrick_vN — Mon, 07 Mar 2016 14:03:43 GMT

Either plan a job only once per day.

Or there is the option of creating a parameter (in TVARVC for instance) where you keep track of the last time the report has ran (or mail has been send). Don't forget to to update the parameter when each time a mail has been send of course.