Formula to create a date for a prior year using variable
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
------------------------------
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
------------------------------
