Days Between *

Alex

if(year(prop("Due Date")) > year(now()), toNumber(formatDate(prop("Due Date"), "DDD")) + 365 - toNumber(formatDate(now(), "DDD")), if(year(prop("Due Date")) < year(now()), toNumber(formatDate(prop("Due Date"), "DDD")) - 365 - toNumber(formatDate(now(), "DDD")), toNumber(formatDate(prop("Due Date"), "DDD")) - toNumber(formatDate(now(), "DDD"))))

Days Until/Since - Decimal ❌

round(dateBetween(prop("Due Date"), now(), "hours") / 24 * 10) / 10

Days Until/Since 🤷🏻‍♂️

or(empty(prop("Due Date")), formatDate(now(), "L") == formatDate(prop("Due Date"), "L")) ? 0 : ceil(dateBetween(prop("Due Date"), now(), "hours") / 24)

Days Until - Decimal ❌

or(empty(prop("Due Date")), now() > prop("Due Date")) ? 0 : (round(dateBetween(prop("Due Date"), now(), "hours") / 24 * 10) / 10)

Days Until 🤷🏻‍♂️

or(empty(prop("Due Date")), or(now() > prop("Due Date"), formatDate(now(), "L") == formatDate(prop("Due Date"), "L"))) ? 0 : ceil(dateBetween(prop("Due Date"), 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>