Hello Please can someone offer some expert advice.<BR><BR>I have a database of books. some are published and others have yet to be published. What I want to do is create a button on a webpage which runs a piece of asp code that searches through the publish date column of the database. What I want it to do is populate a list of all the books that are to be published after the current date. I just don't know the syntax for the following statement:<BR><BR>If pubdate>currentDate then select all those items and write a list of those titles to a new page.<BR><BR>Can someone shed some light?