Crystal Report Date Range Parameters - VisualCron - Forum

Community forum

Bob Lanteigne
2015-10-12T18:17:57Z
I need to specify date variables for a Crystal Report date range parameter. The UI only allows literal date values when setting up the parameters. Am I missing something or is this by design?
ACS
2015-10-12T23:25:24Z
Choose "DateVariableField" for data type
"RangeValue" for Range Type.
Then you will have 2 fields to enter variable dates.

Example 1st of last month, last of last month:
{DATEADD(Months|{DATEFORMAT(yyyy-MM-01)}|yyyy-MM-dd|-1|yyyy-MM-dd)}
{DATEADD(Days|{DATEFORMAT(yyyy-MM-01)}|yyyy-MM-dd|-1|yyyy-MM-dd)}
Bob Lanteigne
2015-10-13T14:53:37Z
Obviously I was missing something. Works perfectly. Thanks.
Scroll to Top