Date subtraction

[Elmserv]

This is some foxpro code which is not too dissimilar to PHP

dDate = date() // todays date


do while dow(dDate) != 0 // dow = day of week
dDate = dDate - 1 // reduce date by 1
enddo

print dDate // depending on the language this would probably be a sunday.

My problem is depricating the date

I have had a few endless loops but the ISP's server is still running (just)

Richard

 

[jpadie]

use date() to determine the day of the week (see

http://www.php.net/date

for the syntax for returning dow).

to decrement the date use

$d = date();
do {
 $d = strtodate("minus 1", $d);}
while (whatever your loop is )

 

[BabyJeffy]

My problem is depricating the date

My problem is understanding what you want. Maybe you could re-phrase what you want.

Cheers,
Jeff

[tt]Jeff's Page @ Code Couch

http://www.codecouch.com/jeff/blog/

http://www.coedit.co.uk/

[/tt]

What is Javascript? FAQ216-6094

 

[jpadie]

oops.. strtodate is in my imagination. should be strtotime()

 

[Elmserv]

Hi Jeff

What I am trying to do is get a start date for a weekly report.

Users will allways put in the wrong date Sun date instead of Sat etc so I was trying to build some code that will step the date backwards until it hits a Sat & that is the start date for the report.

Richard

 

[jpadie]

for what's it's worth

$d = date();
while (date("w",$d) !== 6){  //6=sat, 0=sun
 $d = strtotime("-1 day", $d);
}

 

[Elmserv]

This is what I have come up with

$dDate = $_POST['Date'];


do {
 $dDate = strtotime("minus 1", $dDate);}
while (date('w', $dDate) !== '7')
	
		
Print $Ddate;

will test in a few secs

 

[jpadie]

you seem to be ignoring my posts.

notwithstanding this: your solution probably won't work. for two reasons.

1. it's unlikely a user will post a date in unix timestamp format.
2. you're decrementing the date even before testing it. this will end up with you being a week off if the user gets the date right.

if you're using user input try the following:

$d = strtotime(trim($_POST['Date']));
while (date("w",$d) !== 6){  //6=sat, 0=sun
 $d = strtotime("-1 day", $d);
}

 

[Elmserv]

This is what I finally got to work

$d = strtotime(trim($_POST['Date']));
while (trim(date("w",$d)) !== '6')
	{  //6=sat, 0=sun
 		$d = strtotime("-1 day", $d);
	}

Print date('Y-m-d',$d);

Many thanks for all the help, I appeared to be ignoring you because of the delay between reading the posts trying something out then reposting. Only to find that further comments had come in.

Richard