What db are you using?
-----Original Message-----
From: Mike Belcher [mailto:[EMAIL PROTECTED]
Sent: 10 February 2005 23:22
To: [email protected]
Subject: [AspNetAnyQuestionIsOk] strSQLstring = "SELECT * FROM tblNews WHERE
Newsdate = between date30daysago and date now ORDER by NewsDate DESC"
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
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/
