Question

can i format teh results of datebetween into years and months?

Answer 1

See if this helps. I couldn't think of a way that keeps the month and the year, but there's a way to show up the months:

concat(format(abs(dateBetween(prop("Start date"), prop("End date"), "months"))) + " months")

Or even, if you just want the number:

abs(dateBetween(prop("Start date"), prop("End date"), "months"))

Answer 2

Hi, this formula will give you Years and Months between the set dates.

E.g. if the "Start date" was December 4th 2020 and the "End date" was July 17th 2023 the result would show:

3 Years 7 Months

concat(format(abs(floor(dateBetween(prop("Start date"), prop("End date"), "months") / 12))), " Years ", format(abs(mod(dateBetween(prop("Start date"), prop("End date"), "months"), 12))), " Months")