Global Absence Accrual Matrix || Hire Date DBI ia not working

Summary:

Hi,

I am working on an Absence Fast Formula of type Global Absence Accrual Matrix. My goal is to fetch the hire date of an employee, and in cases of rehire, retrieve the latest hire date.

To achieve this, I have tried multiple DBIs, but all are returning a default value of 12/31/4712 instead of the correct hire date. For instance, my test employee's actual hire date is 10/21/1993, yet every DBI query returns 4712-12-31T00:00:00.000Z.

Could someone please advise why this discrepancy is occurring? Am I using an incorrect DBI or missing a crucial step?

For reference, I am attaching a piece of the Fast Formula and the log files generated.