Reporting Service

[ritumishra01]

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', ..

[Vegar · Accepted solution]

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)&')';