2 Replies Latest reply: Mar 30, 2012 10:37 AM by John Gross RSS

Business Rule Schedule - at a later time variable

Gerwin van Dijken

Hi all,

 

I want a Business Rule that sents a notification email one week before Due Date (of a Work Order). Is that possible?

Or can I only enter fixed date/time in field 'STARTING AT' at the Schedule tab?

 

Regards,

Gerwin.

  • 1. Re: Business Rule Schedule - at a later time variable
    Julie Wynne

    You can do this quite easily using the Expression builder and a MATH statement, combined with the sql dateadd function.   This may not be exact syntax but it will be something like this: {MATH,(SELECT DATEADD(“D”,-7,’{TR,Due Date &Time}’)}

     

    Julie

  • 2. Re: Business Rule Schedule - at a later time variable
    John Gross

    Dear Gerwin,

     

     

     

    The starting date would be the Due Date and the Offset would be -7 days (or -5 days if you include a 5-day Work Schedule).  Remember to use Database Lookups in your conditions to make sure that the values are still the same for the criteria to be valid.  When TR and CUR values are placed in the business rule, as variables they never change their value even if you schedule it far in the future.  Therefore, you use DB Lookups so that at run-time the data will be re-evaluated.

     

     

     

    Met vriendelijke groet,

     

    John