Formula to create a date for a prior year using variable

Question

I have a field [COI Issuance Date] that spans multiple years. I'm trying to write a formula that will tell me the anniversary date of that field for 2020, and another for 2021. I have the field for 2021, using the formula below, which is working fine.

var date COI = [COI Certification Date];
Date(Year(Today()),Month($COI),Day($COI))

How do I write the formula to return the anniversary date of [COI Certification Date] in 2020?

------------------------------
Lauren Jeppson
------------------------------

MarkShnierYou · Answer

try this:Squeeze in the -1var date COI = [COI Certification Date];Date(Year(Today())-1,Month($COI),Day($COI))------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

Sign up

Login to the community