You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Period End Date for Leap year

Summary:


Content (please ensure you mask any confidential information):

I've created a period end date account. But I'm having trouble getting the leap year functionality to work. It was suggested to use the below formula. FY-Index is an account with a member formula, included below.

 @IF (@CalcMgrIsLeapYear ("FY-Index), 229, 228)

FY-Index = @CalcMgrDoubleFromString (@CONCATENATE ("20", @SUBSTRING (@NAME (@CURRMBR (Years)), 2)))

Error parsing formula for [calc-expression] (line 4): wrong number of arguments in function [@IF]

However, when I put it in, I get errors. I tried removing parenthesis, but no luck. Is there another way to get the February end date to work dynamically?
Full member formula below.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!