🔥
Due today/overdue
🔴
Due in ≤ 2 days
🟡
Due in < 7 days
🟢
Due in ≥ 7 days
Status
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"))))
Explanation
if(formatDate(now(), "L") == formatDate(prop("Due date"), "L") or prop("Due date") < now(), "🔥",If the current date in the MM/DD/YYYY format matches that of the Due date, or the Due date is less than the current date, display 🔥
if(dateBetween(prop("Due date"), now(), "days") <= 2, "🔴",Otherwise if the number of days between the Due date and the current date is less than or equal to 2, display 🔴
if(dateBetween(prop("Due date"), now(), "days") < 7, "🟡",Otherwise if the number of days between the Due date and the current date is less than 7, display 🟡
if(dateBetween(prop("Due date"), now(), "days") >= 7, "🟢",Otherwise if the number of days between the Due date and the current date is greater than or equal to 7, display 🟢
"N/A"))))Otherwise display N/A.
