Hi

I have an ASP dynamic page which retrieves a list of diary dates from a MySQL database.

I want to be able to display on the ASP page only the dates which have not yest passed. For example: today, tomorrow and every day after's date should show, but not yesterday's.

Does anyone know how to code this as an SQL statement? I have tried using the date function in the statement: <b>WHERE diaryDate&gt;=Date()</b> but this doesn't seem to work. Am I doing this right?

Any help greatly appreciated.



Edited by - Arcturus on 11 Aug 2006 20:43:22

As far as I know, for MySQL it should be:

WHERE diaryDate &gt;= CURDATE()

Barry

PS: have a look at:
dev.mysql.com/doc/refman/4.1/en/date-and-time-functions.html
Barry

Thanks for the advice.

I have found that the following works great for me.

select * FROM diary WHERE diaryDate &gt;= DATE_SUB(curdate(), INTERVAL 1 DAY)