snowdog Posted December 16, 2006 Share Posted December 16, 2006 I am trying to get the difference bewteen 2 dates in the number of days. ie: difference between 2006-12-8 and 2006-12-15 , The answer is 7, but just subtracting them gives me a 0 . I do not know much about strtotime and have been trying to learn but am just having difficulties with this. Here is what I have$todays_date = date("Y-m-d"); //get start and end dates for their group $query = "select * from group_setup WHERE member_group = $member_group"; $result_setup = mysql_query($query) or die('Query failed: ' . mysql_error()); $show_setup = mysql_fetch_object($result_setup); $start_date = $show_setup->start_date; $end_date = $show_setup->end_date; $date_diff = $todays_date - $start_date; echo $date_diff; Thanks in advance.Snowdog Link to comment https://forums.phpfreaks.com/topic/30833-solved-subtracting-dates-to-come-up-with-a-number/ Share on other sites More sharing options...
doni49 Posted December 16, 2006 Share Posted December 16, 2006 Try rearranging your date format:[code]<?php$date1 = "8 December 2006";$date2 = "12 December 2006";$diffDays = strtotime($date2) - strtotime($date2);echo $diffDays;?>[/code]NOTE: This is off the top of my head and hasn't been tested. Link to comment https://forums.phpfreaks.com/topic/30833-solved-subtracting-dates-to-come-up-with-a-number/#findComment-142202 Share on other sites More sharing options...
snowdog Posted December 16, 2006 Author Share Posted December 16, 2006 ok that gives me a number : 2592000 now how do I convert that into number of days?Snowdog Link to comment https://forums.phpfreaks.com/topic/30833-solved-subtracting-dates-to-come-up-with-a-number/#findComment-142205 Share on other sites More sharing options...
snowdog Posted December 16, 2006 Author Share Posted December 16, 2006 ok got it, the strtotime converst to seconds, there are 86400 seconds in a day so you just have to divide the difference by 86400$date_diff = (strtotime($todays_date) - strtotime($start_date))/86400;echo $date_diff;Thanks for putting me on the right track.Snowdog Link to comment https://forums.phpfreaks.com/topic/30833-solved-subtracting-dates-to-come-up-with-a-number/#findComment-142210 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.