The simplest way to find the number of days in a plan year is to find the beginning and end of the current plan year, or the beginning of the current and next plan years.

 

; A_DT is a single date or an array of date(s) that you need to

; adjust (e.g., DOB field or #DATE in a transformation expression)

 

; Method 1: ------------------------------------------

BOY_DT:= #BEGMTH (2 #FSTBUSDAY A_DT) &

EOY_DT:= #ENDMTH (BOY_DT #DATEPLUS 360D) &

DaysInYear:= 1 + EOY_DT – BOY_DT &

 

; Method 2: ------------------------------------------

BOY_DT:= #BEGMTH (2 #FSTBUSDAY A_DT) &

BOY1_DT:= BOY_DT #DATEPLUS 1Y & ; beginning of next plan year

DaysInYear:= BOY1_DT – BOY_DT &