TOPIC: Current Date/ Specific Time - Defined Parameter

Current Date/ Specific Time - Defined Parameter 29 May 2019 22:33 #5507

  • echan@imperialhealthholdings.com
  • echan@imperialhealthholdings.com's Avatar
  • Offline
I'm trying to set a start/end range for my reports. How do we define a parameter to use the current date, but predetermined time?
Example: Report range will be "Current Date at 6:00am" to "Current Date at 8:00pm"
I only see variables that are %CURRENT_DATE% OR %CURRENT_DATE_TIME%.
Any help will be much appreciated.
Attachments:
The administrator has disabled public write access.

Current Date/ Specific Time - Defined Parameter 24 Jun 2019 18:51 #5645

  • brian@terrytown.com
  • brian@terrytown.com's Avatar
  • Offline
I don't user parameters for dates when I setup automatic reports. Here is an example of how I get last week dates on a report run that is run on Monday.

{ORDR.DocDate} > currentdate - 9 AND {ORDR.DocDate} < currentdate - 1

I put that in my record Selection.

All the best,
Brian
The administrator has disabled public write access.

Current Date/ Specific Time - Defined Parameter 25 Jun 2019 01:14 #5650

  • aellis
  • aellis's Avatar
  • Offline
In addition to Brian's suggestion, if you do find it necessary to set up your report with parameters and you need something a little more fancy than our built-in variables you can always use our VB Script variables as described here:

www.logicitysuite.com/forum/tips-tricks/...ables-reference.html
The administrator has disabled public write access.