Skip to main content
Solved

Help with formula - Blank Field

  • February 3, 2021
  • 2 replies
  • 36 views
C

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

Best answer by Jeremy_Oglesby

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'
)

2 replies

J
Forum|alt.badge.img+18
  • Jeremy_Oglesby
  • Inspiring
  • Answer
  • February 3, 2021

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'
)
C
  • Chris_Allen
  • Author
  • New Participant
  • February 3, 2021

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

Terms & ConditionsAccessibility statement