My Crystal report has a date parameter.
I need the report to run for 'yesterday'.
In the parameter selection, I select the %CURRENT_DATE% variable and the report runs.
If I select %CURRENT_DATE% - 1 as my variable, the report fails as it cannot do the math on the date variable.
How can I configure this parameter & variable to run the report for the current date minus one day (yesterday)?
Thank you.