This small function returns the date (with the format you want) of the previous monday from a given date. If given date is empty it gets the today date:
// usage:
// last monday: $d = findMonday();
// last monday before 31-12-2010: $d = findMonday("2010-12-31");
// last monday before 31-12-2010 with a specific format: $d = findMonday("2010-12-31","m/d/Y");
function findMonday($d="",$format="Y-m-d") {
if($d=="") $d=date("Y-m-d");
$delta = date("w",strtotime($d)) - 1;
if ($delta <0) $delta = 6;
return date($format, mktime(0,0,0,date('m'), date('d')-$delta, date('Y') ));
}
You need to pass the date to the date() calls on the last row, otherwise the returned date will always be the current date minus delta, rather than the specified date minus the delta.
What about:
function findMonday($d = “”, $format = “Y-m-d”) {
return date($format, strtotime(‘last monday’, $d));
}
?
Thank you! Just what I need to complete my sw.
This worked better for me
public function findMonday($datePassed=””,$format=”Y-m-d”) {
$dateObj = new DateTime($datePassed);
$dayOfWeek = $dateObj->format(“N”);
while($dayOfWeek 1){
$dateObj->sub(new DateInterval(‘P1D’));
$dayOfWeek = $dateObj->format(“N”);
}
return $dateObj->format(“Y-m-d”);
}
really good! it works?
Doesn’t work. You probably should have tested this before posting it.
This, however, does work:
function findMonday($d=””,$format=”Y-m-d”) {
if($d==””) $d=date(“Y-m-d”);
$dparts = explode(“-“,$d);
$mydate = mktime(12,0,0,$dparts[1],$dparts[2],$dparts[0]);
$weekday = ((int)date( ‘w’, $mydate ) + 6 ) % 7;
$prevmonday = $mydate – $weekday * 24 * 3600;
return date($format,$prevmonday);
}