Days Left

(prop("Deadline") > now()) ? dateBetween(prop("Deadline"), now(), "days") : 0

(prop("Deadline") > now())

If Deadline is past current date, do the following.

? dateBetween(prop("Deadline"), now(), "days")

Display the number of days between the current date and Deadline

: 0

Otherwise display 0

Priority

empty(prop("Deadline")) ? "" : ((prop("Days Left") == 0) ? "❌ Past Date" : ((prop("Days Left") <= 2) ? "🚨 Danger Zone" : ((prop("Days Left") <= 7) ? "👌 Final Touches" : ((prop("Days Left") <= 14) ? "😤 Get to Work" : ((prop("Days Left") <= 30) ? "👨‍🍳 Prepare" : "")))))

empty(prop("Deadline")) ? ""

If Deadline is empty, display nothing.

: ((prop("Days Left") == 0) ? "❌ Past Date"

Otherwise if Days Left is 0, display Past Date

: ((prop("Days Left") <= 2) ? "🚨 Danger Zone"

Otherwise if Days Left is equal or less than 2, display Danger Zone

: ((prop("Days Left") <= 7) ? "👌 Final Touches"

Otherwise if Days Left is equal or less than 7, display Final Touches

: ((prop("Days Left") <= 14) ? "😤 Get to Work"

Otherwise if Days Left is equal or less than 14, display Get to Work

: ((prop("Days Left") <= 30) ? "👨‍🍳 Prepare" : "")))))

Otherwise if Days Left is equal or less than 30, display Prepare

<aside> ⚠️ Change lowercase w to uppercase W if your weeks start on Monday.

</aside>

This Week

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

Filter

This Week Is ☑️

This Month

formatDate(now(), "MY") == formatDate(prop("Deadline"), "MY")

Filter

This Month Is ☑️

Updates

Entries

<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>