Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

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

Topic Labels: Formulas
536 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Chris_Allen
4 - Data Explorer
4 - Data Explorer

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