<aside> 💡 The Due property below is calculated based on the current date so that the state examples stay the same, this would usually be a regular Date property.

</aside>

Entries

State

if(empty(prop("Due")), "⚪️", if(formatDate(prop("Due"), "L") == formatDate(now(), "L"), "🟢", if(prop("Due") < now(), "🔴", "🔵")))

State (Original)

if(empty(prop("Due")), "⚪️", if(larger(date(now()), date(prop("Due"))) and largerEq(month(now()), month(prop("Due"))) and largerEq(year(now()), year(prop("Due"))), "🔴", if(equal(date(now()), date(prop("Due"))) and equal(month(now()), month(prop("Due"))) and equal(year(now()), year(prop("Due"))), "🟢", "🔵")))

<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 BenLatest • Was this helpful? Please consider buying me a coffee. Cheers!

</aside>