Forum Discussion

DanielTraub's avatar
DanielTraub
Regular Visitor
4 years ago
Solved

Compare Dates with IF Function

Hi all,    I have a table with some start and end dates in it. I want to compare those dates, to today. If today is within the start/end date time frame, then return a result of "in learning perio...
  • johnt75's avatar
    johnt75
    4 years ago
    Learning Period =
IF (
    Installations[Date Learning Period Started] <= TODAY ()
        && TODAY () <= Installations[Expected Learning Period End Date],
    "In Learning Period",
    IF (
        TODAY () > Installations[Expected Learning Period End Date],
        "Pilot in progress",
        IF (
            Installations[Date Learning Period Started] > TODAY (),
            "Upcoming/Pilot Prep"
        )
    )
)
johnt75's avatar
johnt75
Icon for Super User rankSuper User
4 years ago
Learning Period =
IF (
    Installations[Date Learning Period Started] <= TODAY ()
        && TODAY () <= Installations[Expected Learning Period End Date],
    "In Learning Period",
    IF (
        TODAY () > Installations[Expected Learning Period End Date],
        "Pilot in progress",
        IF (
            Installations[Date Learning Period Started] > TODAY (),
            "Upcoming/Pilot Prep"
        )
    )
)
  • DanielTraub's avatar
    DanielTraub
    Regular Visitor
    4 years ago

    This seems to work! Didn't realize I needed that &&. Thanks so much!