Forum Discussion
Solved
date
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 ...
please try;
SLA =
SWITCH(
TRUE(),
TODAY() >= [Rental End], "Overdue",
TODAY() >= DATE([Rental End], -30), "Flag Overdue",
TODAY() >= [Rental End] - 7, "Near Overdue",
"Valid"
)
please try;
SLA =
SWITCH(
TRUE(),
TODAY() >= [Rental End], "Overdue",
TODAY() >= DATE([Rental End], -30), "Flag Overdue",
TODAY() >= [Rental End] - 7, "Near Overdue",
"Valid"
)
thank you, I'll try this one