Birthday formula

Hi people!

I’m building a “Birthdays” table in my “Calendar” base and I’m looking for a formula that says:

if “Birthday” is within the next 2 months then display “soon”

What would this formula look like?


IF(DATETIME_DIFF(TODAY(), {Birthday}, "months")<=2, "Soon")

Thanks Jonathan!

I’m still having a problem here. No errors from the formula but the formula labels ALL of the records as “Soon” in the formula field regardless of date.

Sorry! More complicated than I first realised. Try this:


This should work for any date given in {Birthday}, regardless of year.

It works! but I have to filter out next years birthdays or it goes a bit haywire and can’t be filtered using the “Soon” field once the formula is used.

This topic was solved and automatically closed 3 days after the last reply. New replies are no longer allowed.