❖ Contents

Two Date Properties

Documents

Status

if(empty(prop("Expires")), "🚫 No Expiry Set", if(now() < prop("Expires"), if(dateBetween(prop("Expires"), now(), "days") < 91, "🔥 Expires in " + format(dateBetween(prop("Expires"), now(), "days")) + " days!", "✅ Valid"), "💀 Expired"))

One Date Property

Documents

Status

if(formatDate(start(prop("Issued -> Expires")), "L") == formatDate(end(prop("Issued -> Expires")), "L") or empty(prop("Issued -> Expires")), "🚫 No Expiry Set", if(now() < end(prop("Issued -> Expires")), if(dateBetween(end(prop("Issued -> Expires")), now(), "days") < 91, "🔥 Expires in " + format(dateBetween(end(prop("Issued -> Expires")), now(), "days")) + " days!", "✅ Valid"), "💀 Expired"))

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