Prev
Next
Forums Infor / Lawson Platforms Lawson Landmark

Configuration Console

 5 Replies
 2 Subscribed to this topic
 32 Subscribed to this forum
Sort:
Author
Messages
PD
Veteran Member Send Private Message
Posts: 58
Veteran Member
7/12/2018 8:03 PM

I need to modify the LPL code to calculate AdjustedStartDateLengthOfServiceYears and ContinousEmployementDateLenghtOfServiceYearsCompute  based on Term Date and not Current Date.

How do I do that in Business Class = Employee and Form = Dates?

see attached txt file of delivered LPL code

Thanks

Attachments
weeoooohhhh
Basic Member Send Private Message
Posts: 6
Basic Member
10/18/2019 6:26 PM
Did anyone figure this out? We are looking to do the same. I have created my derived field to get the calculation and it works but I need to look for the 01-01-1753 date in the database which is the null value. How do i look for this in lpl? if (TerminationDate = 01-01-1753) This if statement isn't working but I do not know how to look up an actual date like this
JimY
Veteran Member Send Private Message
Posts: 510
Veteran Member
10/21/2019 9:21 AM
Have you tried changing the value to this: 1753-01-01 00:00:00.000 and put it in quotes?
weeoooohhhh
Basic Member Send Private Message
Posts: 6
Basic Member
10/21/2019 12:26 PM
Yes I have actually: if (TerminationDate = "1753-01-01 00:00:00.000") This still doesn't get picked up either. It's simply a syntax thing. If I knew what the LPL was looking for on the back end then this would be simple ha. Any other suggestions?
JimY
Veteran Member Send Private Message
Posts: 510
Veteran Member
10/21/2019 12:41 PM
Sorry, I don't have any other. Good luck.
weeoooohhhh
Basic Member Send Private Message
Posts: 6
Basic Member
10/22/2019 2:17 PM
Jim, figured it out. So LPL isn't looking for NULL or the 1753 date that shows in the database. It's simply looking for "entered" or "not entered" if (TerminationDate not entered)