[Resolved] Dating Problems

Reformed

I'm having dating problems. Not the kind your thinking of though....okay, well I'm having those too, but that's another forum. I need to perform a query based on a condition between weeks and a month.

I need to perform a query that knows what part of the week it is. So, something like: get all the records between last friday and today (two week gap). And another one has to do the same thing between months, like for the last 28 days.

I once posted a similar question in the forum before and now I can't find it, but some generous code warrior slipped me this jem, which works great for between fridays, but I have no idea how it works.

//we know that day of the week uses 0 for SUN and 6 for SAT
	//so we take the day of the week and add 2 to get the previous friday
	$prevFriday = $day+2;

//ad a condition for saturdays.
if( $day==6 ) {
$prevFriday = 1; 
}


	//format the date. the date is the last friday at 7:00pm
	$endDate= date("Y-m-d", mktime (19,0,0,date("m") 
 ,date("d")-$prevFriday ,date("Y")));

Anyone have any ideas?

LordShryku

That seems rather excessive. You can do the math within your mktime statement.

$weekAgo   = date("Y-m-d", mktime(0,0,0,date("m"),date("d")-7,date("Y")));
$yesterday = date("Y-m-d", mktime(0,0,0,date("m"),date("d")-1,date("Y")));
$monthAgo  = date("Y-m-d", mktime(0,0,0,date("m")-1,date("d"),date("Y")));
$yearAgo   = date("Y-m-d", mktime(0,0,0,date("m"),date("d"),date("Y")-1));

And so forth. You could also use strtotime()....

$weekAgo = date("Y-m-d", strtotime("-1 week");

Reformed

Your good man; don't let anyone tell you otherwise. Thanks a lot for the help. It makes sense already the way your doing it. When it comes to date related stuff I'm always getting confused. This really helps.

TJay

Ok I guess I should have posted this in the newbie area cause you guys are blowing me away.

You did give me some ideas on where to look and I thank you.

What I was looking to do was write a function that I could pass the week# and Day# for the current month and get a date. m d y

It looks like the one makedate function is the one I need.

Thanks again
TJay