Help

Re: Help with formula - Blank Field

Solved
Jump to Solution
387 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Chris_Allen
4 - Data Explorer
4 - Data Explorer

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

1 Solution

Accepted Solutions
Jeremy_Oglesby
14 - Jupiter
14 - Jupiter

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

See Solution in Thread

2 Replies 2
Jeremy_Oglesby
14 - Jupiter
14 - Jupiter

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'
)
Chris_Allen
4 - Data Explorer
4 - Data Explorer

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