Type
Date
Checking if date falls within last week, next week or this week
ifs(
(and(
today().year() == prop("Date").year(),
today().week() == prop("Date").week()
)), "This week",
(and(
today().year() == prop("Date").year(),
today().week()-1 == prop("Date").week()
)), "Last week",
(and(
today().year() == prop("Date").year(),
today().week()+1 == prop("Date").week()
)), "Next week",
""
)