Forum Discussion

MikeMurray's avatar
MikeMurray
Qrew Cadet
6 years ago

I need help with an If formula

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
Formulas and functions
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    6 years ago
    try this


    IF(
    IsNull([Next Certification Due Date]),"No",
    [Next Certification Due Date] >= Today(), "No",
    "Yes") 
  • MikeMurray's avatar
    MikeMurray
    Qrew Cadet
    6 years ago
    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!