Hi Gianni, I had it deleted but was using the wrong variable name . Thanks for your help. Works perfectly.

Gianni, Thanks for your reply. I have now combined the query like below into one init block: select to_char(min(TXN_TIME), 'mm/dd/yyyy hh24:mi:ss'), max(TRANSACTION_DATE) from TRANSACTIONS where TRANSACTION_DATE = (select max(TRANSACTION_DATE) from TRANSACTIONS) I have made all two variables as request variable. The weird…