Help

Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

Date formula referring to 2 feilds

Topic Labels: Formulas
246 2
cancel
Showing results for 
Search instead for 
Did you mean: 

Hello wonderful community! I am still having trouble wrapping my brain around IF/THEN situations and thought I would just ask :slightly_smiling_face:
I have 2 date fields in my record:

Join Date
Cancel Date

I have a formula field that calculates months committed based on todays date that is working great:

DATETIME_DIFF(
NOW(),
{Patronage Since Date},
‘months’
)

But I want to have the formula look for a Cancel date and use that first…and if there is no cancel date to go ahead and use todays date. How to I amend my formula? Thank you so much!

2 Replies 2
DATETIME_DIFF(
   IF({Cancel Date}, {Cancel Date}, NOW()),
   {Patronage Since Date},
   'months'
)

Thank you so much! This seems to have worked perfectly :slightly_smiling_face: