simple query question

[Gasolene]

I want to return results only when the 'DueDate' has passed.

query...

SELECT COUNT(*) AS OutStanding
FROM tblInvoices INNER JOIN tblCustomers ON tblInvoices.customer_id = tblCustomers.customer_id
WHERE tblCustomers.Active = 1
AND DueDate < ".strftime( "%m/%d/%Y", time() )."
AND PaidDate IS NULL

output...

SELECT COUNT(*) AS OutStanding
FROM tblInvoices INNER JOIN tblCustomers ON tblInvoices.customer_id = tblCustomers.customer_id
WHERE tblCustomers.Active = 1
AND DueDate < 11/04/2003
AND PaidDate IS NULL

however this never returns results, there are 'DueDate' fields that occour in the past.

it works fine if I remove the line: "AND DueDate < ".strftime( "%m/%d/%Y", time() )."

[browny]

Hi, you're using the wrong format for the date in the query. I have a very similar query and the comparison is:

"end < $date"

the date needs to be in the following format (already in php for you)
$date=gmDate("Y-m-d");

hope this helps.

[Gasolene]

thnx,