Challenge with Time Off Entry

Hi all,

Wonder if someone could offer me a little help please?

I've built a report on PBO Time Off Entry, data source Time Off - All Statuses for Activated and Terminated Employees.

Report works fine but I have blank Employee Types for Terminated Workers.

I've tried a Calc Field to lookup value as of date to try to get the Employee Type as of Term date but it doesn't work.

Error re "encountered a blank date".

Could anyone help me solve this? Seems like it should be very easy, but I'm struggling.

Thanks all.