01/08/2023 01:01 PM - edited 01/09/2023 11:21 AM
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>
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.