[RESOLVED] date('n/j/Y', strtotime($result[0]->record_entered)) produces yesterday?

[ppowell]

$result[$i]->record_entered contains the current date as set up by MySQL (entered as "now()").

I verified that in the database the date is "now()", which in this case will be "2/9/2006".

However, when viewing the page using the display:

<?= date('n/j/Y', strtotime($result[0]->record_entered)) ?>

I get "2/8/2006" instead, even though the database back-end says "2/9/2006". What's going on?

Thanx
Phil

[devinemke]

what exactly do you see when you do:

echo $result[0]->record_entered;

[ppowell]

Oh crap, STUPID error!

Good thing I caught it with 3 minutes to spare before the presentation!!

<?= date('n/j/Y', strtotime($result[0]->record_entered)); // NO! ?>

<?= date('n/j/Y', strtotime($result[$i]->record_entered;)); // YES! ?>

I had the wrong value in strtotime()

Phil