Skip to main content

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 getting marked as payment complete.


Thanks in advance


Chris

Hi @Chris_Allen


If I understand you correctly, I think you can address this by using some AND() logic in your conditional, like this:


IF(

   AND(

      {Course Payment Duration},

      DATETIME_DIFF(

         TODAY(), 

         {Course Joining Date}, 

         'months'

      ) > {Course Payment Duration}

   ), 

   'Payment Complete'

)

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 Payment Duration should be.


Any ideas?


Chris

Reply


Terms & Conditions