TOPIC: DATE report parameter

DATE report parameter 18 Sep 2015 11:50 #2022

  • friedhoffd
  • friedhoffd's Avatar
  • Offline
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.
The administrator has disabled public write access.

DATE report parameter 18 Sep 2015 14:32 #2023

  • KCrane
  • KCrane's Avatar
  • Offline
Logicity Pro 1.7 introduced the feature of allowing VB Script in the variables used within the Logicity Solution Builder:

www.logicitysuite.com/forum/tips-tricks/...ables-reference.html

Try the following for yesterday:
%{DateAdd("d", -1, Date)}%
The administrator has disabled public write access.