Due In

Display the due status and number of days between the current date and a due date.

Due In
Copy  •  js
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
Copy  •  js
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", "")))
Explanation
Previous & Next