topic Re: Error while running script in Reporting Service & Alerting

Error while running script

ritumishra01 — Fri, 15 Nov 2024 22:04:41 GMT

LET WHERE_PART_TEMP ='AND TRUNC(EBT_CARD_DETL.STAT_DATE) BETWEEN TO_DATE(' & chr(39) &$(FromDateKey)& chr(39) &chr(44) &chr(39)&'MM/DD/YYYY'&chr(39)&') AND TO_DATE(' & chr(39)&$(ToDateKey)& chr(39) &chr(44) &chr(39)&'MM/DD/YYYY'&chr(39)&')';
while runnig this i am getting below error message:

Unexpected token: '&', expected one of: '(', 'Yellow', 'ZTestw_z', 'OPERATOR_PLUS', 'OPERATOR_MINUS', 'not', 'bitnot', ..

Re: Error while running script

Vegar — Fri, 12 Aug 2022 06:52:15 GMT

It could be the $(FromDateKey) and/or $(ToDateKey) that is giving you trouble (if the content is empty or a string), try this adjusted expression.

LET WHERE_PART_TEMP ='AND TRUNC(EBT_CARD_DETL.STAT_DATE) BETWEEN TO_DATE(' & chr(39) &'$(FromDateKey)'& chr(39) &chr(44) &chr(39)&'MM/DD/YYYY'&chr(39)&') AND TO_DATE(' & chr(39)&'$(ToDateKey)'& chr(39) &chr(44) &chr(39)&'MM/DD/YYYY'&chr(39)&')';