Due In

Due In (Original)

if(empty(prop("Done")) == false, "N/A", if(dateBetween(now(), prop("Due"), "days") == 0, "Due today", if(dateBetween(now(), prop("Due"), "days") < 0, concat("Due in ", format(abs(dateBetween(now(), prop("Due"), "days")) + 2), " days"), concat("Overdue by ", format(abs(dateBetween(now(), prop("Due"), "days"))), " days"))))

Due In V2

if(empty(prop("Due")) or not empty(prop("Done")), "", if(formatDate(prop("Due"), "L") == formatDate(now(), "L"), "Due Today", if(floor(dateBetween(now(), prop("Due"), "hours") / 24) > 0, "Overdue by ", "Due in ") + format(abs(floor(dateBetween(now(), prop("Due"), "hours") / 24))) + " day" + if(abs(floor(dateBetween(now(), prop("Due"), "hours") / 24)) > 1, "s", "") + if(floor(dateBetween(now(), prop("Due"), "hours") / 24) >= -7, "‼️", "")))

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