Notion Answers

Help between Notion users


Register & Ask

It's free & easy

Get answers

Answers, votes & comments

Vote and select answers

Receive points, vote and give the solution

Question

1vote

Format number of days into years, months and days

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

1 Answer

1vote

nutsinbox Points290

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

Please log in or register to answer this question.

Exclusive for Notion Answers Users

...

Welcome to Notion Answers, where you can ask questions and receive answers from other members of the community.

Please share to grow the Notion Community!

Connect