Announcing the Saviynt Knowledge Exchange unifying the Saviynt forums, documentation, training,
and more in a single search tool across platforms. Read the announcement here.
No ratings
SB
Saviynt Employee
Saviynt Employee

Symptoms

The application should be able to send yesterday's date in the End date field. Currently it is sending todays date when using 

<endDate>${(new Date()).format('MM-dd-yyyy')}</endDate>

 

Solution

We need to use SUB function in order to send Yesterdays' date.

DATE_SUB is used for yesterdays date and DATE_ADD is used for tomorrow's date

Correct expression to be used  DATE_SUB(CURDATE(), INTERVAL 1 DAY)

NOTE:  The new keyword in no longer supported in json and has been removed due to security restrictions.

Version history
Last update:
‎01/09/2023 11:21 AM
Updated by:
Saviynt Employee
Contributors