Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

Trying to use "if" and "date difference" together

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

Hi! My formula to flag an older blog post as in need of an update isn’t working and I’m not sure why. Here’s the formula:

IF(DATETIME_DIFF({Date Last Updated},TODAY(), ‘months’) > 12, “Update”, " ")

The logic I want is this:
If more than 12 months have elapsed between the date indicated in the {Date Last Updated} field and today, I would like the cell to say “Update.” Else, blank.

Can anyone advise?

2 Replies 2

Welcome to the community, @Lia_Garcia! :grinning_face_with_big_eyes: If the first date passed to DATETIME_DIFF() is older than the second one, the result will be a negative number, which means the comparison to see if that number is greater than 12 will never be true. This could be solved by either swapping the first two arguments:

IF(DATETIME_DIFF(TODAY(), {Date Last Updated}, 'months') > 12, "Update")

…or changing the comparison to look for a number less than -12:

IF(DATETIME_DIFF({Date Last Updated}, TODAY(), 'months') < -12, "Update")

In both of these, notice how I left off the empty string at the end. The final piece of an IF() function is optional; if omitted, it will automatically return the proper blank value based on the data type that the other portion returns.

Worked like a charm! Thank you!