Skip to main content

Hello wonderful community! I am still having trouble wrapping my brain around IF/THEN situations and thought I would just ask 🙂

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!

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

Thank you so much! This seems to have worked perfectly 🙂


Reply