Skip to main content (Press Enter).
Sign in
Skip auxiliary navigation (Press Enter).
Support
Quick Base University
Skip main navigation (Press Enter).
Toggle navigation
Content types
Announcements
Blogs
Communities
Discussions
Events
Glossary
Site Content
Libraries
Date range
on this day
between these dates
Posted by
Home
Getting Started
Communities
All Communities
My Communities
Celebrate
What's New
Events
User Groups
Browse
Discussion Posts
Library Entries
Discussions
View Only
Community Home
Discussion
32.8K
Library
10
Blogs
91
Events
0
Members
3.7K
Back to discussions
Expand all

Collapse all
sort by most recent
sort by thread
How to calculate the number of months between 2 dates
Amber Polston
04162019 14:57
Simply, I need a formula to calculate the number of months a vehicle has been in service. I have a ...
Jeff Mickelsen
04162019 16:52
Try this https://community.quickbase.com/quickbase/topics/howdoideterminethenumberofmonths...
Amber Polston
04162019 18:46
This worked great! Thank you!
Alex Certification!
04162019 17:05
Do you need the answer in whole months? Rounded up or down? Or fractional months? Or months + days?
Amber Polston
04162019 18:47
I would only want to show the whole months. So if the calculation went into a partial month, I wo...
Alex Certification!
04162019 19:25
Did you get it working based on Mark's formula from the other thread?
Amber Polston
04182019 13:03
Yes, it worked perfectly!
1.
How to calculate the number of months between 2 dates
1
Like
Amber Polston
Amber Polston
Posted 04162019 14:57
Reply
Reply Privately
Options Dropdown
Simply, I need a formula to calculate the number of months a vehicle has been in service. I have a [In Service Date]. So I am thinking something like Today()[In Service Date]=xxxMonths
2.
RE: How to calculate the number of months between 2 dates
0
Like
Jeff Mickelsen
Posted 04162019 16:52
Reply
Reply Privately
Options Dropdown
Try this
https://community.quickbase.com/quickbase/topics/howdoideterminethenumberofmonthsbetweentwodates
3.
RE: How to calculate the number of months between 2 dates
0
Like
Amber Polston
Posted 04162019 18:46
Reply
Reply Privately
Options Dropdown
This worked great! Thank you!
4.
RE: How to calculate the number of months between 2 dates
0
Like
Bronze
Contributor
Alex Certification!
Posted 04162019 17:05
Reply
Reply Privately
Options Dropdown
Do you need the answer in whole months? Rounded up or down? Or fractional months? Or months + days?
5.
RE: How to calculate the number of months between 2 dates
0
Like
Amber Polston
Posted 04162019 18:47
Reply
Reply Privately
Options Dropdown
I would only want to show the whole months. So if the calculation went into a partial month, I would want it to round up to the next whole number.
6.
RE: How to calculate the number of months between 2 dates
0
Like
Bronze
Contributor
Alex Certification!
Posted 04162019 19:25
Reply
Reply Privately
Options Dropdown
Did you get it working based on Mark's formula from the other thread?
7.
RE: How to calculate the number of months between 2 dates
0
Like
Amber Polston
Posted 04182019 13:03
Reply
Reply Privately
Options Dropdown
Yes, it worked perfectly!
×
New Best Answer
This thread already has a best answer. Would you like to mark this message as the new best answer?
Skip Navigation Links
Terms and Conditions
Copyright . All rights reserved.
Powered by Higher Logic