The application should be able to send yesterday's date in the End date field. Currently it is sending todays date when using
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.