Unix Time Stamp for last year

[NZ_Kiwis]

Quick Question:
How can I get the time stamp of this time last year

Full Question:
I have a access database (*.mdb) and I want to loop though all results counting each one that has a date stamp with inside the last year, yes each row has a column that has a Unix Time Stamp and if that is within a year of today it's counted.

So

I can loop though all results counting them I just need some kind of If Statement getting today's TimeStamp but how can I work out what the timestamp of this time last year was?

[bradgrafelman]

strtotime('-1 year');

While I'm not familiar with Access databases, if you can perform SQL queries (e.g. via ODBC?), then you could just add a WHERE condition to only select the rows you want rather than looping through every row and doing some comparison logic in PHP.

[NZ_Kiwis]

Thanks, I'll into the Select WHERE option but in the mean time I would just want to look at results

if (strtotime('-1 year') < $TimeInColumn) {
$Count++
}

Correct?

[NZ_Kiwis]

That works after testing. Thanks

how can I go back to the 1st of March but make it so i don't have to re code it each year, so now it will go back to mar 2010 in Feb it will do the same in Jun next year it will back to mar 2011?????????????

Thanks heaps

[johanafm]

See date

$time = mktime(0, 0, 0, 3, date('j'), date('Y') - 1);

[NZ_Kiwis]

johanafm;10964696 wrote:

See date

$time = mktime(0, 0, 0, 3, date('j'), date('Y') - 1);

in April 2011 would that find March 2011 or March 2010??

[NZ_Kiwis]

no it does not :-(

I want to go back to the most recent Mar 29 20XX

[NZ_Kiwis]

I can get the current month date and month number can i somehow do a check to see if it's past Mar 30?

$now = time();
$date = date('d n', $now);

if ($date > '03 30'){
	echo "true";
} else {
	echo $false;
}

[johanafm]

Ah, now I get what you're after. You don't need the separate call to time() and the intermediate variable. Also, checking against the month is enough if you're dealing with the last day (31st) rather than the 30th.

if (date('j') < 4) {
# use previous year
}
else {
# this year
}

[NZ_Kiwis]

not really, I want to count rows that are in the last 'financial year' so 1 year back to the latest 31 march..........

[NZ_Kiwis]

<?php
$now = time();
$year = date('Y', $now);
echo date('n', $now);

if (date('n') > 4){
	echo "This Year";
	$Oneyear = mktime(0, 0, 0, 7, 1, date('Y'));
	echo $Oneyear;
} else {
	echo "Go Back One Year";
	$Oneyear = mktime(0, 0, 0, 7, 1, date('Y') - 1);
	echo $Oneyear;
}
?>

THis show Jun 29, why?

[johanafm]

NZ_Kiwis;10964833 wrote:

THis show Jun 29, why?

To me it shows july 1 of either 2009 (if change the if condition) or 2010.

echo date('Y-m-d', $Oneyear);

NZ_Kiwis;10964778 wrote:

$now = time();
$date = date('d n', $now);

if ($date > '03 30'){
	echo "true";
} else {
	echo $false;
}

You don't have day and month in the same order in the call to date and in the string literal. Also, the month must come first as it's the most significant of the two

$date = date('n d', $now);