Termination analysis does not bring all records when dynamic dates are used

Summary

When a hard coded dates are used in the analysis or date is entered through the prompt selection, it works fine. However when the range is determined dynamically it does not work.

Content

Hi Experts,

I'm using the following dynamic dates to calculate the beginning and ending dates for termination analysis for a dashboard:

"Worker"."Termination Date"  >= (greater than or equal to) TIMESTAMPADD(SQL_TSI_YEAR,-1,@{asofdate}{CURRENT_DATE})

to

"Worker"."Termination Date"  <= (less than or equal to) asofdate

This brings most of the records but missing some latest records. However, the same analysis works fine when I hard code the same date (e.g. 5/15/2020 - 5/15/2021).