<aside> ☑️ Original formula by hgrmty from Discord

</aside>

Entries

Date 1 – Date 2 (Original)

concat(format(dateBetween(prop("Date 2"), prop("Date 1"), "years")), "y ", format(dateBetween(prop("Date 2"), dateAdd(prop("Date 1"), dateBetween(prop("Date 2"), prop("Date 1"), "years"), "years"), "months")), "m ", format(dateBetween(prop("Date 2"), dateAdd(dateAdd(prop("Date 1"), dateBetween(prop("Date 2"), prop("Date 1"), "years"), "years"), dateBetween(prop("Date 2"), dateAdd(prop("Date 1"), dateBetween(prop("Date 2"), prop("Date 1"), "years"), "years"), "months"), "months"), "days")), "d")

Date 1 – Now (Original)

concat(format(dateBetween(now(), prop("Date 1"), "years")), "y ", format(dateBetween(now(), dateAdd(prop("Date 1"), dateBetween(now(), prop("Date 1"), "years"), "years"), "months")), "m ", format(dateBetween(now(), dateAdd(dateAdd(prop("Date 1"), dateBetween(now(), prop("Date 1"), "years"), "years"), dateBetween(now(), dateAdd(prop("Date 1"), dateBetween(now(), prop("Date 1"), "years"), "years"), "months"), "months"), "days")), "d")

Date 1 – Date 2

(empty(prop("Date 1")) or empty(prop("Date 2"))) ? "" : concat(format(abs(dateBetween(prop("Date 2"), prop("Date 1"), "years"))), "y ", format(abs(dateBetween(prop("Date 2"), dateAdd(prop("Date 1"), dateBetween(prop("Date 2"), prop("Date 1"), "years"), "years"), "months"))), "m ", format(abs(dateBetween(prop("Date 2"), dateAdd(dateAdd(prop("Date 1"), dateBetween(prop("Date 2"), prop("Date 1"), "years"), "years"), dateBetween(prop("Date 2"), dateAdd(prop("Date 1"), dateBetween(prop("Date 2"), prop("Date 1"), "years"), "years"), "months"), "months"), "days"))), "d")

Date 1 – Now

empty(prop("Date 1")) ? "" : concat(format(abs(dateBetween(now(), prop("Date 1"), "years"))), "y ", format(abs(dateBetween(now(), dateAdd(prop("Date 1"), dateBetween(now(), prop("Date 1"), "years"), "years"), "months"))), "m ", format(abs(dateBetween(now(), dateAdd(dateAdd(prop("Date 1"), dateBetween(now(), prop("Date 1"), "years"), "years"), dateBetween(now(), dateAdd(prop("Date 1"), dateBetween(now(), prop("Date 1"), "years"), "years"), "months"), "months"), "days"))), "d")

Date 1 – Date 2 (Long)

(empty(prop("Date 1")) or empty(prop("Date 2"))) ? "" : (if(abs(dateBetween(prop("Date 2"), prop("Date 1"), "years")) != 0, format(abs(dateBetween(prop("Date 2"), prop("Date 1"), "years"))) + " year" + if(abs(dateBetween(prop("Date 2"), prop("Date 1"), "years")) != 1, "s ", " "), "") + if(abs(dateBetween(prop("Date 2"), dateAdd(prop("Date 1"), dateBetween(prop("Date 2"), prop("Date 1"), "years"), "years"), "months")) != 0, "" + format(abs(dateBetween(prop("Date 2"), dateAdd(prop("Date 1"), dateBetween(prop("Date 2"), prop("Date 1"), "years"), "years"), "months"))) + " month" + if(abs(dateBetween(prop("Date 2"), dateAdd(prop("Date 1"), dateBetween(prop("Date 2"), prop("Date 1"), "years"), "years"), "months")) != 1, "s ", " "), "") + if(abs(dateBetween(prop("Date 2"), dateAdd(dateAdd(prop("Date 1"), dateBetween(prop("Date 2"), prop("Date 1"), "years"), "years"), dateBetween(prop("Date 2"), dateAdd(prop("Date 1"), dateBetween(prop("Date 2"), prop("Date 1"), "years"), "years"), "months"), "months"), "days")) != 0, "" + format(abs(dateBetween(prop("Date 2"), dateAdd(dateAdd(prop("Date 1"), dateBetween(prop("Date 2"), prop("Date 1"), "years"), "years"), dateBetween(prop("Date 2"), dateAdd(prop("Date 1"), dateBetween(prop("Date 2"), prop("Date 1"), "years"), "years"), "months"), "months"), "days"))) + " day" + if(abs(dateBetween(prop("Date 2"), dateAdd(dateAdd(prop("Date 1"), dateBetween(prop("Date 2"), prop("Date 1"), "years"), "years"), dateBetween(prop("Date 2"), dateAdd(prop("Date 1"), dateBetween(prop("Date 2"), prop("Date 1"), "years"), "years"), "months"), "months"), "days")) != 1, "s", ""), ""))

Date 1 – Now (Long)

empty(prop("Date 1")) ? "" : (if(abs(dateBetween(now(), prop("Date 1"), "years")) != 0, format(abs(dateBetween(now(), prop("Date 1"), "years"))) + " year" + if(abs(dateBetween(now(), prop("Date 1"), "years")) != 1, "s ", " "), "") + if(abs(dateBetween(now(), dateAdd(prop("Date 1"), dateBetween(now(), prop("Date 1"), "years"), "years"), "months")) != 0, "" + format(abs(dateBetween(now(), dateAdd(prop("Date 1"), dateBetween(now(), prop("Date 1"), "years"), "years"), "months"))) + " month" + if(abs(dateBetween(now(), dateAdd(prop("Date 1"), dateBetween(now(), prop("Date 1"), "years"), "years"), "months")) != 1, "s ", " "), "") + if(abs(dateBetween(now(), dateAdd(dateAdd(prop("Date 1"), dateBetween(now(), prop("Date 1"), "years"), "years"), dateBetween(now(), dateAdd(prop("Date 1"), dateBetween(now(), prop("Date 1"), "years"), "years"), "months"), "months"), "days")) != 0, "" + format(abs(dateBetween(now(), dateAdd(dateAdd(prop("Date 1"), dateBetween(now(), prop("Date 1"), "years"), "years"), dateBetween(now(), dateAdd(prop("Date 1"), dateBetween(now(), prop("Date 1"), "years"), "years"), "months"), "months"), "days"))) + " day" + if(abs(dateBetween(now(), dateAdd(dateAdd(prop("Date 1"), dateBetween(now(), prop("Date 1"), "years"), "years"), dateBetween(now(), dateAdd(prop("Date 1"), dateBetween(now(), prop("Date 1"), "years"), "years"), "months"), "months"), "days")) != 1, "s", ""), ""))

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