Skip to main content
Question

I need help with an If formula

  • May 30, 2019
  • 0 replies
  • 14 views
The formula I'm using now, for annual certification is "If(IsNull([Next Certification Due Date]),"No","Yes") in a Formula Text field named Certified?. It works OK,  but I want to mark Certification Due Dates that are due before to day (overdue) as "No". Tried a few different formulas but to no avail.
Thank you
Mike
    This topic has been closed for replies.

    try this


    IF(
    IsNull([Next Certification Due Date]),"No",
    [Next Certification Due Date] >= Today(), "No",
    "Yes") 
    • MikeMurray
    • Author
    • Registered
    • May 31, 2019
    Just tried it, changed >=Today() to <= Today & it worked.
    I have to cut back on using too many )))'s Thanks for bailing me out again!
    Terms & ConditionsAccessibility statement