Hi,

I have a report built using InfoAssist. The report is on a Portal however we want to schedule output using ReportCaster (as users are interested in receiving a scheduled output). The report has a date range as a parameter, however, when automated using the tool, we would like to cover a rolling date range of a month.

Unfortunately, the scheduled report (using ReportCaster), the start date value of "DATEADD ( '&YYMD.EVAL' , 'D' , -30 )" and the end date value of "DATEADD ( '&YYMD.EVAL' , 'D' , -1 )" are throwing runtime errors

 
(FOC177) INVALID DATE CONSTANT: 43637
(FOC282) RESULT OF EXPRESSION IS NOT COMPATIBLE WITH THE FORMAT OF FIELD: Dfn_RangeStartDate_DMYY
(FOC177) INVALID DATE CONSTANT: 43666
(FOC282) RESULT OF EXPRESSION IS NOT COMPATIBLE WITH THE FORMAT OF FIELD: Dfn_RangeEndDate_DMYY
(FOC177) INVALID DATE CONSTANT: 43637
(FOC177) INVALID DATE CONSTANT: 43666
(FOC177) INVALID DATE CONSTANT: 43637
(FOC177) INVALID DATE CONSTANT: 43666

I have struggled to find out a solution for the above problem.

Any ideas will be hugely appreciated.

Kind regards,

Manoj.

This message has been edited. Last edited by: Manoj,

Manoj

This is just a guess but based on the field name Dfn_RangeStartDate_DMYY I think you are using the wrong variable in your DATEADD try using &DMYY

quote:

Originally posted by Manoj:
... "DATEADD ( '&YYMD.EVAL' , 'D' , -30 )"

(FOC177) INVALID DATE CONSTANT: 43637

Your problem is that DATEADD returns a integer and not a date and your WHERE clause seems to look for a date.

YYMD, DMYY, ... should normally not cause issue when performing WHERE clauses; they are display format
But in case, try with the following:

DATETRAN(DTADD('&YYMD.EVAL', DAY, -30), '(DMYY)', '(/)', 'EN', 10, 'A10')

DATETRAN(DTADD('&YYMD.EVAL', DAY,  -1), '(DMYY)', '(/)', 'EN', 10, 'A10')

Many thanks, Chuck and Martin.

Martin, your solution is working without any issues. It should give me a different content (data) tomorrow which I shall confirm tomorrow. Meanwhile, thanks.

Kind regards,

Manoj.

Hi Martin,
I have re-tested the report this morning. Output files are generated without any error and with the expected data.
Thank you very much.
Kind regards,
Manoj.