Calculations
Posted: Fri Oct 15, 2004 7:13 am
Hi all.
I'm trying to perform the following calculation:
Take yesterday's number of "Active Users" away from today's number of "Active users" and present the results.
I have a query that's executed each time a page is opened that inserts Date/Time into a field and number of active users.
How can I grab the last entry before today's date though and use that value...?
Hope I've explained that OK.
I'm using the Date/time format of:
So now would be: 2004-10-15 13:13:45
Is what I am asking impossible maybe...?
I'm trying to perform the following calculation:
Take yesterday's number of "Active Users" away from today's number of "Active users" and present the results.
I have a query that's executed each time a page is opened that inserts Date/Time into a field and number of active users.
How can I grab the last entry before today's date though and use that value...?
Hope I've explained that OK.
I'm using the Date/time format of:
Code: Select all
$Time = date("Y-m-d H:i:s");Is what I am asking impossible maybe...?