Thanks Cetin, it works like a charm. I added distinct clause for bdate to get one value like following:

SELECT top 1 DISTINCT (bdate) FROM ;
payroll!payroll_tbl ;
where bdate <= .t1.value ;
order by 1 desc ;
into array a__gen3
ldLTEDate = iif(_Tally=0,{},a__gen3)


thanks again
nick patel