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
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
    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
      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
        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
          Posts: 510
          Veteran Member
          10/21/2019 12:41 PM
            Sorry, I don't have any other. Good luck.
            weeoooohhhh
            Basic Member
            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)