${if(len((select max(substr(crtim,1,2)) from SAPBI.ZKBS where to_char(crdat, 'YYYY-MM-DD') = (select current_date "current_date" from dummy) ))==0,
"and to_char(a.crdat, 'YYYY-MM-DD') = (select current_date "current_date" from dummy)
and substr(a.crtim,1,2) =
(select max(substr(crtim,1,2)) from SAPBI.ZKBS
where to_char(crdat, 'YYYY-MM-DD') = (select current_date "current_date" from dummy)
) ",
"and to_char(a.crdat, 'YYYY-MM-DD') = (select add_days(current_date,-1) "current_date" from dummy)
and substr(a.crtim,1,2) =
(select max(substr(crtim,1,2)) from SAPBI.ZKBS
where to_char(crdat, 'YYYY-MM-DD') = (select add_days(current_date,-1) "current_date" from dummy)
)")}