No ratings
sahil
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:
Contributors