I have account_info_date in format "01/01/2016 00:00:00 AM IST"
SELECT INSTITUTION_ID,AMOUNT,PERIOD_INDICATOR,ACCOUNT_INFO_DATE
FROM FA_FIN_INDICATOR_COMPUTATION
WHERE INSTITUTION_ID=%{institution_id} and ACCOUNT_INFO_DATE=%{account_info_date}
Getting missing right parenthesis or SQL not ended properly error
can you try to put single quotes around the macros?
SELECT INSTITUTION_ID,AMOUNT,PERIOD_INDICATOR,ACCOUNT_INFO_DATE
FROM FA_FIN_INDICATOR_COMPUTATION WHERE INSTITUTION_ID='%{institution_id}' AND ACCOUNT_INFO_DATE='%{account_info_date}'
can you try to put single quotes around the macros?
SELECT INSTITUTION_ID,AMOUNT,PERIOD_INDICATOR,ACCOUNT_INFO_DATE
FROM FA_FIN_INDICATOR_COMPUTATION WHERE INSTITUTION_ID='%{institution_id}' AND ACCOUNT_INFO_DATE='%{account_info_date}'
Altair Employee
can you try to put single quotes around the macros?
Greetings,
Jonas