Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

IF Formula date - update field exactly when the month is reached

Topic Labels: Formulas
226 0
cancel
Showing results for 
Search instead for 
Did you mean: 

Hello,

I have this formula below:

IF(
AND(
{Course Payment Duration},
DATETIME_DIFF(
TODAY(),
{Course Joining Date},
‘months’
) > {Course Payment Duration}
),
‘Payment Complete’
)

this formula is meant to tell me when as user has paid a subscription based on the amount of months it been since they joined but it seems to only show payment complete when the next complete month has passed.

An example is if the Course payment duration is 3 months the payment complete only changes when it it’s 3 months + the days of that month have passed.

I need the payment complete to change when the 3 months have been reached.

Hope someone can help

Chris

0 Replies 0