000038323 - Calculating Leap Year Dates in RSA Archer

Document created by RSA Customer Support Employee on Jan 9, 2020
Version 1Show Document
  • View in full screen mode

Article Content

Article Number000038323
Applies ToRSA Product Set: RSA Archer
RSA Product/Service Type: RSA Archer
RSA Version/Condition: 6x
IssueThere is no built-in function for end of month in RSA Archer. This is especially an issue when determining if it is a leap year.

ResolutionThere are many ways to figure it out and use that information. Here are a few:
  1. Values List Field - calculated values list
    [Leap Year?] - Yes if Leap Year, No if not

    IF(OR ( MOD(YEAR(Now()),400)=0, AND(MOD(YEAR(now()),4)=0,MOD([Year],100)<>0)),VALUEOF([Leap Year?],"Yes"),VALUEOF([Leap Year?],"No") ) 
  2. Numeric Field - calculated field
    Returns 366 if Leap Year, 365 if not

    Datedif(DATETIMEVALUE( "1/1/" & YEAR( now() )),DATETIMEVALUE( "12/31/" & YEAR( now() )),DAY)+
Either may be used as a helper field or embedded in a calculation to determine correct February end of month.