Calculate current day < expiry date

0
Hi,   We have certain orders that have a expiry date. Once this expiry date is reached, the order needs to get a certain status. How would I do this?  
asked
2 answers
5

Hi Ian Trouw,

 

This issue is solved using Scheduled Event concept with the help of microflow .

 

 

set that interval fields which you wish,

 

In that microflow , add  retrieve your appropriate  activity the Xpath constraint ( [ExpiryDate >= '[%BeginOfCurrentDay%]'] [ExpiryDate <= '[%EndOfCurrentDay%]'] )

 

answered
0

Hi Ian,

You would run a nightly scheduled event that retrieves all orders from the database that exceed the expiry date. You can then iterate over the expired orders and set the status to Expired.

Hope that helps.

answered