Date & Time Status

Status

if(empty(prop("Date & Time")), "", if(formatDate(end(prop("Date & Time")), "L") == formatDate(now(), "L"), "🟩", if(formatDate(end(prop("Date & Time")), "L") == formatDate(dateAdd(now(), 1, "days"), "L"), "🟦", if(end(prop("Date & Time")) < now(), "🟥", format(ceil(dateBetween(dateSubtract(dateSubtract(end(prop("Date & Time")), hour(end(prop("Date & Time"))), "hours"), minute(end(prop("Date & Time"))), "minutes"), now(), "hours") / 24))))))

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