PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 10/22/2019 10:17 AM by  weeoooohhhh
Configuration Console
 5 Replies
Sort:
You are not authorized to post a reply.
Author Messages
PD
Technical Assoc Manager
Private
Veteran Member
(103 points)
Veteran Member
Posts:55


Send Message:

--
07/12/2018 4: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
    Software Engineer
    Private
    Basic Member
    (16 points)
    Basic Member
    Posts:6


    Send Message:

    --
    10/18/2019 2: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
    Private
    Private
    Veteran Member
    (1426 points)
    Veteran Member
    Posts:506


    Send Message:

    --
    10/21/2019 5:21 AM
    Have you tried changing the value to this: 1753-01-01 00:00:00.000 and put it in quotes?
    weeoooohhhh
    Software Engineer
    Private
    Basic Member
    (16 points)
    Basic Member
    Posts:6


    Send Message:

    --
    10/21/2019 8:26 AM
    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
    Private
    Private
    Veteran Member
    (1426 points)
    Veteran Member
    Posts:506


    Send Message:

    --
    10/21/2019 8:41 AM
    Sorry, I don't have any other. Good luck.
    weeoooohhhh
    Software Engineer
    Private
    Basic Member
    (16 points)
    Basic Member
    Posts:6


    Send Message:

    --
    10/22/2019 10:17 AM
    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)
    You are not authorized to post a reply.