🔥 Due today/overdue
🔴 Due in ≤ 2 days
🟡 Due in < 7 days
🟢 Due in ≥ 7 days
if(formatDate(now(), "L") == formatDate(prop("Due date"), "L") or prop("Due date") < now(), "🔥", if(dateBetween(prop("Due date"), now(), "days") <= 2, "🔴", if(dateBetween(prop("Due date"), now(), "days") < 7, "🟡", if(dateBetween(prop("Due date"), now(), "days") >= 7, "🟢", "N/A"))))
<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>
