Date Interval Confusion.

[Kold]

Hi.

I am trying to find the number of database entries for a certain user on a particular day. I am getting stuck on the current day part.

The part of my query for this is as follows;

WHERE ((DATE_SUB( CURDATE( ) , INTERVAL 1 DAY ) <= `Date_Entered`)

It doesnt seem to be working though, I suspect it may be getting the same time as the day before - is this correct? I need the day to start at midnight, and finish at midnight. How can I do this?

Thank you!

[nemonoman]

WHERE DATE_FORMAT(CURRENT_DATE()-INTERVAL 1 DAY,'%Y%m%d')<=DATE_FORMAT(Date_Entered,'%Y%m%d')