if(empty(prop("Dates")), "", if(formatDate(end(prop("Dates")), "L") == formatDate(now(), "L"), "Due Today", if(end(prop("Dates")) < now(), "Overdue", "—")))
if(empty(prop("Dates")), "",
Check to see if Dates is empty, and if it is display nothing. Otherwise do the following.
if(formatDate(end(prop("Dates")), "L") == formatDate(now(), "L"), "Due Today",
If the localised DD/MM/YYYY format of Dates matches that of the current date, display Due Today.
if(end(prop("Dates")) < now(), "Overdue",
Otherwise if the end date of Dates is less than (before) the current date, display Overdue.
"—")))
Otherwise if the end date of Dates is greater than (after) the current date, display —
<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>
