Devart Forums

Hello

version v6.90.0.53+BDS2006

with following SQL, the two macros are not able to be identified into Macros.

select *
from dpa
where dpa.PERIOD_START_TIME >=
to_date('&start_datetime', 'yyyymmddhh24')
and dpa.PERIOD_START_TIME <=
to_date('&end_datetime', 'yyyymmddhh24')

Please kindly check it

You cannot use macros inside string constants. Remove quotes from the macro name. Assing a value with quotes for the macro instead.