Tp-EndDate is acting like Tp-Date and is breaking our Start Date calculations

Summary:

After numerous tests, I can prove that the TP-EndDate member, though when retrieved is one value...when it is in IF statements it is another value

Content (required):

OK here we go.

Below is a screenshot of retrieved data. Please note the OWP_Action is Missing, the Start Date is 10/15/21, the TP-EndDate is 20211031 and TP-Date is 20211000 and TP-Days is 31. So far everything is as expected! So when we run PLD / Calc Comp it should calculate and change Action to Active, and give salary info....but it doesn't - it stays #MISSING.

After numerous tests (shown in the code), we took a random account (AC_Vacancy Adjustment) and set it equal to TP-EndDate....as you can see, it instead returns the value of TP-Date...so the OWP_Action IF statement of "TP-EndDate ' => "OWP_Start Date" doesn't become true and so we dont get an active employee in the month of October.