how to compare fields, I have to field due date and actual complete date.

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered

how do I write a formula to count 1 if  due date and actual complete fields are both in the same month , then if the due date and actual complete date are different months 0, and then if the actual complete date is blank then ""

Photo of Shontay

Shontay

  • 490 Points 250 badge 2x thumb

Posted 3 years ago

  • 0
  • 1
Photo of dwhawe

dwhawe, Champion

  • 908 Points 500 badge 2x thumb
Try this:

If(IsNull([Complete Date]),Null,

Month([Complete Date])=Month([Due Date]),1,

0)