Is there a way to set up a date calculator between two date columns?

Feature requests
1

I have two date columns-- one with dates in the past, one with dates in the future.

Is there a way to set up an automation that notifies me if the future column, when the date is entered, is a certain number of months after the before date?

I.e. Before date is March 2, 2020. After date is July 17, 2023
I need a notification, when that after date is entered, that tells me if it is 24 months between the two dates or not.

I also need this notification 30 days before the after date, to make things more complicated, lol

Thanks!!

2

replace the {hire date} and {term date} with the columns you are trying to calculate the difference of.

INT(YEARFRAC(FORMAT_DATE({Hire date}), FORMAT_DATE(({Term date})))) & " Years " &
INT(MOD(YEARFRAC(FORMAT_DATE({Hire date}), FORMAT_DATE(({Term date}))), 1) * 12) & " Months " &
INT(MOD(YEARFRAC(FORMAT_DATE({Hire date}), FORMAT_DATE(({Term date}))) * 12, 1) / 12 * 365) & " Days"

image
image1106×93 10.8 KB