Sign in to follow this  
Followers 0
gcue

datediff (months and years)

6 posts in this topic

im trying to get the date difference in months and years

$months = _DateDiff('M', $start_date, $end_date)

$years = $months / 12

how do i figure out how many months there are when its .3 for instance??

Share this post


Link to post
Share on other sites



#2 ·  Posted (edited)

What is "its"? years or months?

Do you have an example with real dates to test?

Edited by water

My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (NEW 2017-04-18 - Version 1.4.8.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (NEW 2017-02-27 - Version 1.3.1.0) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2015-04-01 - Version 0.4.0.0) - Download - General Help & Support - Example Scripts
Excel - Example Scripts - Wiki
Word - Wiki
PowerPoint (2015-06-06 - Version 0.0.5.0) - Download - General Help & Support

Tutorials:
ADO - Wiki

 

Share this post


Link to post
Share on other sites

#3 ·  Posted (edited)

gcue,

If you need a Integer call for both years and months, you could do something like this:

$total_months = _DateDiff('M', $start_date, $end_date)

$years = Floor($total_months / 12)

$months = $total_months-($years*12)

Realm

Edit: Fixed an error I wrote in the code.

Edited by Realm

My Contributions: Unix Timestamp: Calculate Unix time, or seconds since Epoch, accounting for your local timezone and daylight savings time. RegEdit Jumper: A Small & Simple interface based on Yashied's Reg Jumper Function, for searching Hives in your registry.  

Share this post


Link to post
Share on other sites

#4 ·  Posted (edited)

hmm the result of these gives me 1 year and 11 months

$start_date = 2008-11-19 00:00:00

$end_date = 2010-11-02 00:00:00

thanks for your help realm!

water - sorry i wasnt clear. trying to get a more accurate change in datediff (showing # of years and months - to the nearest month). so like the dates shown above should be 2 years and 0 months?

Edited by gcue

Share this post


Link to post
Share on other sites

#5 ·  Posted (edited)

You only get full months and years so the result is correct!

Edited by water

My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (NEW 2017-04-18 - Version 1.4.8.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (NEW 2017-02-27 - Version 1.3.1.0) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2015-04-01 - Version 0.4.0.0) - Download - General Help & Support - Example Scripts
Excel - Example Scripts - Wiki
Word - Wiki
PowerPoint (2015-06-06 - Version 0.0.5.0) - Download - General Help & Support

Tutorials:
ADO - Wiki

 

Share this post


Link to post
Share on other sites

ooooo ur right!

sorry about that realm.. thanks water!!!

and thanks again realm =)

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now
Sign in to follow this  
Followers 0