jph826
asked on
Identify dates as even or odd years
How do I identify a year in a date as even or odd? I need a formula like this:
if {BENEFIT.START_DATE} year is an even year (for example 2016) then {BENEFIT.COV_OPTION_1}
else
if {BENEFIT.START_DATE} year is an odd year (for example 2017) then {BENEFIT.COV_OPTION_2}
Thanks!
if {BENEFIT.START_DATE} year is an even year (for example 2016) then {BENEFIT.COV_OPTION_1}
else
if {BENEFIT.START_DATE} year is an odd year (for example 2017) then {BENEFIT.COV_OPTION_2}
Thanks!
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.