Hi ,
I am trying to write a business rule where I want to create one condition to check whether the date value of a column is greater than today’s date+7 days. I now in the expression field i can write now() to get today’s date but how will I get a date which 7days in future.
Please help me here.
Best answer by Isuru Wijeratna
According to you needs to use the expression in input, you have to check use expression when you setup the input parameters.
and then use the expression as below
it is checking whether the created_dttm of the record is leass than now()-days(7) and the cust_prob_descr is changed. if so only it shows the allert.
expression : request.created_dttm < now() - days(7)
Note: if you use expression, Operator should be Expression. ( Business Rule help guide page 89-90 )
Hi,
You can add seconds/hours/minutes/days to now() - your expression should look something like this:
TABLE.COLUMN_NAME > NOW() + DAYS(7)SECONDS(), MINUTES(), HOURS(), and DAYS() all take an integer as a parameter to add to a date and time
Hi Ethan,
Thanks for the information. I tried with this but it seems like not working. I have attached the screen shot below. Please check and correct me if I am wrong anywhere.
Expressions are done a little differently than basic comparisons for input parameters - there are a couple things you need to change
Hope this helps!
+21According to you needs to use the expression in input, you have to check use expression when you setup the input parameters.
and then use the expression as below
it is checking whether the created_dttm of the record is leass than now()-days(7) and the cust_prob_descr is changed. if so only it shows the allert.
expression : request.created_dttm < now() - days(7)
Note: if you use expression, Operator should be Expression. ( Business Rule help guide page 89-90 )
+3Imagine if i want do block an insertion when the TASK.EARLIEST_START_DTTM LIKE "01/01/9999 00:00:00"
How do i define that in the expression?
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
