Ben SmithBen Smith
Ben Smith/
Last/This/Next Week
Last/This/Next Week
Last/This/Next Week

Last/This/Next Week

For
Oliver
From
Facebook
Status
Updating
Formulas
+
+
formatDate
formatDate
|| · or
|| · or
now
now
toNumber
toNumber
Share
Master DB

Combined

Last/This/Next Week

Uses multiple or operators to compare formatted dates, and checks a box if any are true.
⚠️
Change lowercase w to uppercase W if your weeks start on Monday.
formatDate(now(), "wY") == formatDate(prop("Date"), "wY") or (format(toNumber(formatDate(now(), "w")) - 1) + formatDate(prop("Date"), "Y") == formatDate(prop("Date"), "wY") or format(toNumber(formatDate(now(), "w")) + 1) + formatDate(prop("Date"), "Y") == formatDate(prop("Date"), "wY"))
formatDate(now(), "wY") == formatDate(prop("Date"), "wY")
The current date's wY format matches the Date property's wY format.
format(toNumber(formatDate(now(), "w")) - 1) + formatDate(prop("Date"), "Y") == formatDate(prop("Date"), "wY")
The current date's wY format minus 1 week (last week) matches the Date property's wY format.
format(toNumber(formatDate(now(), "w")) + 1) + formatDate(prop("Date"), "Y") == formatDate(prop("Date"), "wY")
The current date's wY format plus 1 week (next week) matches the Date property's wY format.

Separate

Master DB
⚠️
Change lowercase w to uppercase W if your weeks start on Monday.

Week

formatDate(prop("Date"), "W")

Last Week

format(toNumber(formatDate(now(), "W")) - 1) + formatDate(prop("Date"), "Y") == formatDate(prop("Date"), "WY")

This Week

formatDate(now(), "wY") == formatDate(prop("Date"), "wY")

Next Week

format(toNumber(formatDate(now(), "W")) + 1) + formatDate(prop("Date"), "Y") == formatDate(prop("Date"), "WY")
 
By Ben • Latest • Was this helpful? Please consider buying me a coffee. Cheers!By Ben • Latest • Was this helpful? Please consider buying me a coffee. Cheers!
By Ben • Latest • Was this helpful? Please consider buying me a coffee. Cheers!