Hi All,

I have the following SQL statement that is "supposed" to only pull records that have been created in the 24 hours. It is sort of working, it pulls in records within the 24 hour period, but they have to be for the prior day. If I create a record today, then run the page that has the SQL it does not pull the record. If I manually change the date to yesterday it works fine.

I need help since I am very green to SQL.

THANKS

SQL CODE:
SELECT *
FROM breaking
WHERE (((breaking.breakdate)>=Date()-1) AND ((breaking.breaktime)>=Time()))


THANKS

-Peter