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, "‼️", "")))

By Ben • Latest • Was this helpful? Please consider buying me a coffee. Cheers!