Please note that VisualCron support is not actively monitoring this community forum. Please use our contact page for contacting the VisualCron support directly.


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?
Sponsor
Forum information
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