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

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

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