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)
