Jump to content
Sign in to follow this  
gcue

datediff (months and years)

Recommended Posts

gcue

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
water

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 2018-12-03 - Version 1.4.11.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (2018-10-31 - Version 1.3.4.1) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example Scripts
PowerPoint (2017-06-06 - Version 0.0.5.0) - Download - General Help & Support
Excel - Example Scripts - Wiki
Word - Wiki
 
Tutorials:

ADO - Wiki

 

Share this post


Link to post
Share on other sites
Realm

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
gcue

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
water

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

Edited by water

My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (NEW 2018-12-03 - Version 1.4.11.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (2018-10-31 - Version 1.3.4.1) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example Scripts
PowerPoint (2017-06-06 - Version 0.0.5.0) - Download - General Help & Support
Excel - Example Scripts - Wiki
Word - Wiki
 
Tutorials:

ADO - Wiki

 

Share this post


Link to post
Share on other sites
gcue

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  

×