Best way to find the months between two dates

by

Start by defining some test cases, then you will see that the function is very simple and needs no loops

from datetime import datetime

def diff_month(d1, d2):
    return (d1.year - d2.year) * 12 + d1.month - d2.month

assert diff_month(datetime(2010,10,1), datetime(2010,9,1)) == 1
assert diff_month(datetime(2010,10,1), datetime(2009,10,1)) == 12
assert diff_month(datetime(2010,10,1), datetime(2009,11,1)) == 11
assert diff_month(datetime(2010,10,1), datetime(2009,8,1)) == 14

You should add some test cases to your question, as there are lots of potential corner cases to cover – there is more than one way to define the number of months between two dates.

More Related Contents:

  1. How to print a date in a regular format?
  2. Convert UTC datetime string to local datetime
  3. How to make a timezone aware datetime object in Python?
  4. Pandas Dataframe line plot display date on xaxis
  5. Adding days to a date in Python
  6. How to convert integer timestamp to Python datetime
  7. How can I account for period (AM/PM) using strftime?
  8. Parsing datetime strings containing nanoseconds
  9. Number of days between 2 dates, excluding weekends
  10. Get current time in milliseconds in Python?
  11. Generating random dates within a given range in pandas
  12. Inserting a Python datetime.datetime object into MySQL
  13. datetime from string in Python, best-guessing string format
  14. Converting string “Jun 1 2005 1:33PM” into datetime
  15. pandas to_datetime parsing wrong year
  16. Python/Pandas convert string to time only
  17. Convert Pandas Series to DateTime in a DataFrame
  18. Convert dataframe index to datetime
  19. How to add/subtract time (hours, minutes, etc.) from a Pandas DataFrame.Index whos objects are of type datetime.time?
  20. How to get current date and time from GPS unsegment time in python
  21. How to convert a Date string to a DateTime object?
  22. Seaborn tsplot does not show datetimes on x axis well
  23. Group DataFrame in 5-minute intervals
  24. Formatting “yesterday’s” date in python
  25. Get UTC offset from time zone name in python
  26. Python: Datetime to season
  27. finding last business day of a month in python
  28. Python strptime parsing year without century: assume prior to this year?
  29. Pandas datetimes with different formats in the same column
  30. Get weekday/day-of-week for Datetime column of DataFrame

Leave a Comment