gcue 10 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?? Share this post Link to post Share on other sites
water 2,391 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 2020-10-10 - Version 1.5.2.1) - Download - General Help & Support - Example Scripts - WikiOutlookEX (NEW 2020-12-15 - Version 1.6.3.1) - Download - General Help & Support - Example Scripts - WikiOutlookEX_GUI (2020-06-27 - Version 1.3.2.0) - DownloadOutlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - WikiExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example ScriptsPowerPoint (2017-06-06 - Version 0.0.5.0) - Download - General Help & SupportExcel - Example Scripts - WikiWord - WikiTask Scheduler (2019-12-03 - Version 1.5.1.0) - Download - General Help & Support - WikiTutorials:ADO - Wiki, WebDriver - Wiki Share this post Link to post Share on other sites
Realm 18 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. Share this post Link to post Share on other sites
gcue 10 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 Share this post Link to post Share on other sites
water 2,391 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 2020-10-10 - Version 1.5.2.1) - Download - General Help & Support - Example Scripts - WikiOutlookEX (NEW 2020-12-15 - Version 1.6.3.1) - Download - General Help & Support - Example Scripts - WikiOutlookEX_GUI (2020-06-27 - Version 1.3.2.0) - DownloadOutlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - WikiExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example ScriptsPowerPoint (2017-06-06 - Version 0.0.5.0) - Download - General Help & SupportExcel - Example Scripts - WikiWord - WikiTask Scheduler (2019-12-03 - Version 1.5.1.0) - Download - General Help & Support - WikiTutorials:ADO - Wiki, WebDriver - Wiki Share this post Link to post Share on other sites
gcue 10 Posted November 2, 2010 ooooo ur right! sorry about that realm.. thanks water!!! and thanks again realm =) Share this post Link to post Share on other sites