You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

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

Question
11
Views
0
Comments
edited Nov 19, 2021 3:50PM in Planning

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.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!