gcue Posted November 2, 2010 Share Posted November 2, 2010 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?? Link to comment Share on other sites More sharing options...
water Posted November 2, 2010 Share Posted November 2, 2010 (edited) What is "its"? years or months? Do you have an example with real dates to test? Edited November 2, 2010 by water My UDFs and Tutorials: Spoiler UDFs:Active Directory (NEW 2022-02-19 - Version 1.6.1.0) - Download - General Help & Support - Example Scripts - WikiExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example ScriptsOutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - WikiOutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - DownloadOutlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - WikiPowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - WikiTask Scheduler (NEW 2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki Standard UDFs:Excel - Example Scripts - WikiWord - Wiki Tutorials:ADO - WikiWebDriver - Wiki Link to comment Share on other sites More sharing options...
Realm Posted November 2, 2010 Share Posted November 2, 2010 (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 November 2, 2010 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. Link to comment Share on other sites More sharing options...
gcue Posted November 2, 2010 Author Share Posted November 2, 2010 (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 November 2, 2010 by gcue Link to comment Share on other sites More sharing options...
water Posted November 2, 2010 Share Posted November 2, 2010 (edited) You only get full months and years so the result is correct! Edited November 2, 2010 by water My UDFs and Tutorials: Spoiler UDFs:Active Directory (NEW 2022-02-19 - Version 1.6.1.0) - Download - General Help & Support - Example Scripts - WikiExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example ScriptsOutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - WikiOutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - DownloadOutlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - WikiPowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - WikiTask Scheduler (NEW 2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki Standard UDFs:Excel - Example Scripts - WikiWord - Wiki Tutorials:ADO - WikiWebDriver - Wiki Link to comment Share on other sites More sharing options...
gcue Posted November 2, 2010 Author Share Posted November 2, 2010 ooooo ur right! sorry about that realm.. thanks water!!! and thanks again realm =) Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now