Ben SmithBen Smith
Ben Smith/
Y, M, & D Between
Y, M, & D Between
Y, M, & D Between

Y, M, & D Between

For
Rezuk4
From
Discord
Status
Updating
Formulas
abs
abs
concat
concat
dateAdd
dateAdd
dateBetween
dateBetween
empty
empty
format
format
if
if
|| · or
|| · or
Share
☑️
Original formula by hgrmty from Discord
 
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", ""), ""))
 
By Ben • Latest • Was this helpful? Please consider buying me a coffee. Cheers!By Ben • Latest • Was this helpful? Please consider buying me a coffee. Cheers!
By Ben • Latest • Was this helpful? Please consider buying me a coffee. Cheers!