Upcoming Birthday Notification

It’s literally just wrapping a single IF() function around the longer formula I wrote above. Assuming the birthday date field in your base is named Birthday, it should work. Just for completeness, though, here’s the whole shebang:

IF(Birthday,
    IF(
        IS_SAME(
            DATETIME_PARSE(
                DATETIME_FORMAT(
                    Birthday,
                    'MMMM D'
                ) & ' ' &
                YEAR(
                    TODAY()
                ),
                'MMMM D YYYY'
            ),
            TODAY()
        ),
        "🎉 🎂 🎉",
        IF(
            ABS(DATETIME_DIFF(
                DATETIME_PARSE(
                    DATETIME_FORMAT(
                        Birthday,
                        'MMMM D'
                    ) & ' ' &
                    YEAR(
                        TODAY()
                    ),
                    'MMMM D YYYY'
                ),
                TODAY(),
                'days'
            )) < 8,
            "🎂"
        )
    )
)
1 Like

Hi Justin, what software do you use to build this formula? I tried to do this in a simple texteditor but the tabs are positioned differently.

Regards,
André

Thanks Justin, your help and time is very much appreciated :slight_smile:

I use BBEdit on the Mac for editing complex formulas. If it’s not nested too deeply, I’ll do it directly in the Airtable editor. Depending on your editor, you may be able to edit the tab settings to your liking.

Thank you so much! I’m so happy with this. You make my day :grin: :grin:

1 Like