[Resolved] Dates

furious5

I'm currently having a problem with a date calculation and cannot for the life in work out what is happening.

Basically I want to search for records, in the last 24hrs, 7 days, 14 days and 1 month.

I am using this code to do the date calculation

$numdays = date('Y-m-d', mktime(0,0,0,date('d'), date('m')-$date, date('Y')));

But I can't see what is wrong, maybe I've been starring at the code for a bit too long.

Any ideas?

stolzyboy

so you want 4 separate sections...

stolzyboy

anyway, you can do this

$twentyfourhours = date ("Y-m-d", strtotime ("- 24 hours"));
$sevendays = date ("Y-m-d", strtotime ("- 7 days"));
$fourteendays = date ("Y-m-d", strtotime ("- 14 days"));
$onemonth = date ("Y-m-d", strtotime ("- 1 month"));

not sure how you are doing it, but this is how you can get those values

Weedpacket

stolzyboy's got the best method, methinks, but FWIW, the last three arguments to mktime() are in "month, day, year" order...

furious5

Stolzyboy thank you for that, I'll have a look at the code this evening.

furious5

I've just had a quick look at this code, but when I print the date I get:

2003-11-15 for any date I try and pass.

Currently put this in a function like so:

function convertDate($date){ // Convert String to Actual Date

	if($date = "1"){
		$date = date ("Y-m-d", strtotime ("- 24 hours"));
	}

	if($date = "7"){ 
		$date = date ("Y-m-d", strtotime ("- 7 days")); 
	}

	if($date = "14"){
		$date = date ("Y-m-d", strtotime ("- 14 days")); 
	}

	if($date = "30"){
		$date = date ("Y-m-d", strtotime ("- 1 month")); 
	}
	return $date; 		
}

Calling the function like this

$numdays = convertDate($date);

Any ideas?? 😕

stolzyboy

if you want it like this mm/dd/yyyy, change this

Y-m-d

to this

m/d/Y

furious5

Indeed that was my next port of call once I had solved the problem with it not doing the date calculation.

Any ideas stolzyboy?

stolzyboy

Guess you got me confused now, what is the problem...

furious5

My problem is whatever date calculation I try to perform e.g:

if($date = "7"){
$date = date ("Y-m-d", strtotime ("- 7 days"));
}

if($date = "14"){
$date = date ("Y-m-d", strtotime ("- 14 days"));
}

The only value I get back is: 2003-11-15 whether it is a month ago, 7 days ago, 14 days ago etc

stolzyboy

oh, i see how, you need to take out the space between the minus sign and the number, so this

14, change to -14

furious5

Hmm still stumped.

The calculation works for 1 month, but when trying to do the calculation for -24 hours, -7 days, -14 days it is still returning a different date of: 2003-09-15

stolzyboy

are you SURE you are getting into the different if statements...

do a

echo "in 24 hours"; or for whatever section it is, just to make sure you are getting into the correct if statements

stolzyboy

also where is $date coming from, the querystring, if so, try $_GET['date'] instead of $date in your if's

furious5

Resolved - that was me!!

I just used a string of if statements instead of using if / elseif, to select the correct argument.

Thank you for your help stolzyboy, I will mark the thread as resolved just to make you even happier. 😉

stolzyboy

Weedpacket

I'd point out that the main cause of grief would have been using '=' instead of '==' in the if statements.

You could sharpen it a bit:

function convertDate($date){ // Convert String to Actual Date
$days=array(
	'1'=>'-1 day',
	'7'=>'-7 days',
	'14'=>'-14 days',
	'30'=>'-1 month');
if(isset($days[$date])
	return date('Y-m-d', strtotime($days[$date]);
else // passed an invalid period.
	return false;
}