matfish Posted June 14, 2007 Share Posted June 14, 2007 Hi, Im having to do a bit of string manipulation and with the given values I need help trying to find out the last day of the month... Im passing the date format of: yyyymm (200706 being this month)(and im unable to change this for several reasons) and Im using substr to find the first 4 chars as the year and the last 2 chars of the month. With these two values I need to find the last day of the month (in this case last day of this month would be 30) At the end I then do an sql query where timestamp>=yyyy-mm-01 AND timestamp<=yyyy-mm-dd (where dd is the last day of the month value im trying to find.) Any ideas with the above issue? Many thanks! Link to comment https://forums.phpfreaks.com/topic/55561-weird-date-format-and-last-day-of-the-month/ Share on other sites More sharing options...
kenrbnsn Posted June 14, 2007 Share Posted June 14, 2007 Use the "t" format of the date() function: <?php $date = "200707"; $days_in_month = date('t',strtotime($date . '01')); echo $days_in_month; ?> Ken Link to comment https://forums.phpfreaks.com/topic/55561-weird-date-format-and-last-day-of-the-month/#findComment-274501 Share on other sites More sharing options...
matfish Posted June 15, 2007 Author Share Posted June 15, 2007 Many thanks! Works a treat Link to comment https://forums.phpfreaks.com/topic/55561-weird-date-format-and-last-day-of-the-month/#findComment-275223 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.