Forum Discussion

Robyrubyjane's avatar
Robyrubyjane
Frequent Visitor
3 years ago
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 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"

Need Help
  • jaweher899's avatar
    jaweher899
    3 years ago

    please try;

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

2 Replies

  • jaweher899's avatar
    jaweher899
    Impactful Individual
    3 years ago

    please try;

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