I have a news database that when displayed I want to list the articles from
the current date to 30 days ago. How can this be done with a SQL String...


strSQLstring = "SELECT * FROM tblNews WHERE Newsdate = between date30daysago
and date now ORDER by NewsDate DESC"

that is what I am trying to accomplish..........


Mike Belcher 







 
Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/AspNetAnyQuestionIsOk/

<*> To unsubscribe from this group, send an email to:
    [EMAIL PROTECTED]

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.com/info/terms/
 



Reply via email to