I need help with formula field. I need to calculate donor's who are lapsed 12 months and 2 weeks ago. I was able to do it for 12 months ago but I dont know how to write a formula for 2 weeks ago. Please advise.
ADDMONTHS(DATE(YEAR( TODAY() ),MONTH( TODAY() ), 01), -12) - 1
Thank you,
Neeraja
13 answers
