Published Shifts DBI fetching wrong or incomplete values

Hello all,

I'm using two DBIs to extract the published shifts in Time and Labor Fast Formulas.
I've used ANC_PUBLISHED_SHIFT_START_ARR in Time Calculation Rule FF and it works fine with no problem. Only needed to use CHANGE_CONTEXTS for it. However, using it in Time Entry Rule FF it doesn't return any value and I checked by returning the size of the array and it's returning 6 values that exist in this DBI.

The other DBI I'm using is HWM_PUB_SCHD_ALL_START_TIME to also extract published shifts in the same area.
This DBI is returning wrong values. It stops on the date before the end of the time card period. I've tried using CHANGE_CONTEXTS to add 1 minute to the context: HWM_CTX_SEARCH_END_DATE by using ADD_DAYS formula but it didn't change anything.