Date Tests

Current Week

if(empty(prop("Date")), false, formatDate(prop("Date"), "WY") == formatDate(now(), "WY"))

Current Month

if(empty(prop("Date")), false, formatDate(prop("Date"), "MY") == formatDate(now(), "MY"))

Next Week

if(empty(prop("Date")), false, formatDate(prop("Date"), "WY") == formatDate(dateAdd(now(), 1, "weeks"), "WY"))

Next Month

if(empty(prop("Date")), false, formatDate(prop("Date"), "MY") == formatDate(dateAdd(now(), 1, "months"), "MY"))

Previous Week

if(empty(prop("Date")), false, formatDate(prop("Date"), "WY") == if(formatDate(prop("Date"), "M") == formatDate(dateSubtract(now(), 1, "weeks"), "M"), formatDate(dateSubtract(now(), 1, "weeks"), "WY"), formatDate(dateSubtract(now(), 1, "weeks"), "W") + formatDate(now(), "Y")))

Previous Month

if(empty(prop("Date")), false, formatDate(prop("Date"), "MY") == formatDate(dateSubtract(now(), 1, "months"), "MY"))

Combined

if(empty(prop("Date")), "", if(formatDate(prop("Date"), "WY") == formatDate(now(), "WY"), "• Curr W", "") + if(formatDate(prop("Date"), "MY") == formatDate(now(), "MY"), " • Curr M", "") + if(formatDate(prop("Date"), "WY") == formatDate(dateAdd(now(), 1, "weeks"), "WY"), " • Next W", "") + if(formatDate(prop("Date"), "MY") == formatDate(dateAdd(now(), 1, "months"), "MY"), " • Next M", "") + if(formatDate(prop("Date"), "WY") == if(formatDate(prop("Date"), "M") == formatDate(dateSubtract(now(), 1, "weeks"), "M"), formatDate(dateSubtract(now(), 1, "weeks"), "WY"), formatDate(dateSubtract(now(), 1, "weeks"), "W") + formatDate(now(), "Y")), " • Prev W", "") + if(formatDate(prop("Date"), "MY") == formatDate(dateSubtract(now(), 1, "months"), "MY"), " • Prev M", ""))

<aside> <img src="https://s3-us-west-2.amazonaws.com/secure.notion-static.com/1649d2f9-1b45-478a-86b4-341fbe27e06f/benny.png" alt="https://s3-us-west-2.amazonaws.com/secure.notion-static.com/1649d2f9-1b45-478a-86b4-341fbe27e06f/benny.png" width="40px" /> By Ben • Latest • Was this helpful? Please consider buying me a coffee. Cheers!

</aside>