can i format teh results of datebetween into years and months?
Connect
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
2 Answers
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"))
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")
Related questions
- Countdown (Years, Months, Weeks, Days, Hours, and Minutes)
- Same date for start and finish properties to result in an output of 1
- Counting the number of days in a date range based on the year (how to split day between 2023 and 2024)
- Help with formula for recurring date and date formating
- Using start() and end() nested in if function nested in dateBetween function
Without Answer
-
- 18
- 0
- 20 hours ago
-
- 19
- 0
- 1 day ago
-
- 15
- 0
- 2 days ago
-
- 21
- 0
- 3 days ago
-
- 27
- 0
- 5 days ago
-
- 52
- 0
- Apr 28
-
- 47
- 0
- Apr 25
-
- 32
- 0
- Apr 25
- see all
Exclusive for Notion Answers Users
- • Dynamic Calendar Icon | Info | Download
- Add yours here
Recent Activities
Fabricio asked 15 hours ago
How can i import a HTML file?tomneser asked 1 day ago
How can I get Notion AI to draw out answers from m…ingevandenbrakel asked 2 days ago
How can I disable notifications for individuals me…JimRaynor commented 2 days ago
EMERGENCY: Lost access to all private pages in tea…polle commented 2 days ago
EMERGENCY: Lost access to all private pages in tea…
...