Skip to main content

What's wrong with my formula?

  • June 9, 2016
  • 1 reply
  • 15 views
H
Forum|alt.badge.img+4

Did I miss something? It was working until I tried to add two IS_BEFORE together

IF(IS_BEFORE({End Date},TODAY()) + (IS_BEFORE({Start Date}, TODAY()) > 1, “Upcoming Class”,“Previous Class”)

    This topic has been closed for replies.

    1 reply

    H
    Forum|alt.badge.img+4
    • Hashim_Warren
    • Author
    • Known Participant
    • June 9, 2016

    Fixed it:

    IF(IS_BEFORE({Start Date}, TODAY()) > 0, IF(IS_BEFORE({End Date}, TODAY()) > 0, “Previous Class”,“Current Class”),“Upcoming Class”)

    Terms & ConditionsAccessibility statement