date

[Robyrubyjane]

hi I want to ask, so I have data like this rental start and rental end, I want the output in the SLA column if today's date is close to the rental end date then the output will be "near overdue", if today's date has reached the rental end then the output will be "overdue" but if today's date has passed from the rental end date maybe about a month then the output will be "flag overdue"

[jaweher899 · Accepted solution]

please try;

SLA =
SWITCH(
TRUE(),
TODAY() >= [Rental End], "Overdue",
TODAY() >= DATE([Rental End], -30), "Flag Overdue",
TODAY() >= [Rental End] - 7, "Near Overdue",
"Valid"
)

[Robyrubyjane]

thank you, I'll try this one