Forum Discussion

Kyle_Wolfe_Ohio's avatar
Kyle_Wolfe_Ohio
Regular Visitor
2 years ago
Solved

Complex IF or ISBLANK

I have a pretty complex script & I am stuck on the final WHERE component. The following image is straight from the table that captures the "Date Filled" and "Date Vacated" information I need to use f...
  • Greg_Deckler's avatar
    Greg_Deckler
    2 years ago

    Kyle_Wolfe_Ohio Maybe: 

    Is Vacant? =
VAR vToday =
    TODAY ()
VAR vResult =
    SWITCH (
        TRUE,
        [Date Filled] = BLANK() && [Date Vacated] = BLANK(), "Yes",
        [Date Vacated] <> BLANK() && [Date Vacated] >= [Date Filled], "Yes",
        "No"
    )
RETURN
vResult
Greg_Deckler's avatar
Greg_Deckler
Community Champion
2 years ago

Kyle_Wolfe_Ohio Maybe: 

Is Vacant? =
VAR vToday =
    TODAY ()
VAR vResult =
    SWITCH (
        TRUE,
        [Date Filled] = BLANK() && [Date Vacated] = BLANK(), "Yes",
        [Date Vacated] <> BLANK() && [Date Vacated] >= [Date Filled], "Yes",
        "No"
    )
RETURN
vResult
Kyle_Wolfe_Ohio's avatar
Kyle_Wolfe_Ohio
Regular Visitor
2 years ago

That worked! Thanks