Find the previous Monday given any date

[zulubanshee]

Say a user selects a date--call it Wed 2009-02-18.
I need to find out the date of the previous Monday. With respect to the this example, I want to get 2009-02-16.

[zulubanshee]

Incidentally, all dates will be in the past.

[ag_47]

May be a better way, but simple one:

$today = $user_selected-date; //in Unix timestamp format (1234.. ) 
while(date('D', $today) != 'Mon'){ 
$today -= 60*60*24; //minus 1 day 
}

[zulubanshee]

I found this on this board. A little longer but it works :)

$now = date('Y-m-d h:m:s', strtotime("now"));
echo $now."<br/>";
$some_date = '2009-01-25';
$found = 0;
$i=0;
while(!$found)
{
$find_monday = date("Y-m-d", strtotime('+'.$i.' monday'));
if($some_date > $find_monday )
{
echo "$find_monday is the monday you were looking for<br/>";
$found = 1;
break;
}
else
$i--;
}

[eeek]

$today = $user_selected-date; //in Unix timestamp format (1234.. ) 
while(date('D', $today) != 'Mon'){ 
$today -= 60*60*24; //minus 1 day 
}

You want to loop to find a Monday? It'd be a lot easier to get the day of the week as a number and subject the proper number of days to get to Monday.

[Habtom]

Try something like the following:

date("Y-m-d", strtotime("Previous Monday", $selectedate));

// $selectedate = timestamp of the date selected

[edited by: Habtom at 5:14 am (utc) on Mar. 25, 2009]

[rocknbil]

USE MYSQL! :-) This makes it so very easy . . . .

For just previous Monday,

select date_add(curdate(), interval 0-weekday(curdate()) day);

Monday and Friday,

select date_add(curdate(), interval 0-weekday(curdate()) day) as Monday, date_add(curdate(), interval 4-weekday(curdate()) day) as Friday;

.... etc. ....

[zulubanshee]

ok thank you all