Date calculations

unknown

How do you calculate dates in LPL

Something like the difference between Start Date till end of year of start date.

Say the start date is 1/Dec/2020 then the number of days output should be 31 (31-Dec-2020 - 1-dec-2020 +1) else it should be 365 if start date not in current year

I would create a compute field that auto computes the difference between end of year and start date if in current year in days else it should be 365 if start date is not in current year

The equivalent of the below IPA javascript code

(StartDate.substring(0,4)==todayAGS().substring(0,4))?(DateDiff(pfDate(StartDate.substring(0,4)+"1231",'yyyymmdd'),pfDate(StartDate,'yyyymmdd'))+1 ):365

Dr. Awesome

A few flavors.  You can simply subract Date and Timestamp fields to get the difference between.

CurrentDateMinus5Days is a ComputeField
   type is Date
   (current date - 5 days)

AgeCompute is a ComputeField //@External - Baseline
   type is Decimal size 6.4
   ((AgeDate - Birthdate) / 365.24)

StartDateLengthOfServiceYearsCompute is a ComputeField
   type is Decimal size 4.2
   restricted
   ((current date - StartDate) / 365.25)

DaysInTerminationDatePriorMonth is a DerivedField
   type is Numeric 2
   restricted
   HoldDate = TerminationDate - 1 month
   LocalAnalysisDays = HoldDate days in month
   return LocalAnalysisDays

Other examples

HoldDate + 1 year

HoldDate - 1 day

ReportingYearEndDateString is a StringField
   type is Alpha size 8
   restricted
   "20211231"

ReportingYearEndDate is a DerivedField
   type is Date
   restricted
   return ReportingYearEndDateString