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 ...
Hello, here is my formula below
IF(DATETIME_DIFF(TODAY(), {Course Joining Date}, ‘months’) > {Course Payment Duration}, ‘Payment Complete’, ‘’)
What I need is to ignore the course payment duration field if it is blank, at the minute this is still get...
That is perfect, this has worked thank you.
I have one more question -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 complete a month after the Course...
