WHERE (Newsdate > DATEADD(d, - 8, { fn NOW() })) AND (StartDate < '" &
Format(Now(),"d") & "')
Okay wow I will give that a try. Wow that looks complex. I haven't learned
much about the date functions. I guess I should find a place to read up on
it.
-----Original Message-----
From: BobFilipiak [mailto:[EMAIL PROTECTED]
Sent: Friday, February 11, 2005 10:16 AM
To: [email protected]
Subject: Re: [AspNetAnyQuestionIsOk] strSQLstring = "SELECT * FROM tblNews
WHERE Newsdate = between date30daysago and date now ORDER by NewsDate DESC"
Try:
WHERE (Newsdate > DATEADD(d, - 8, { fn NOW() })) AND (StartDate < '" &
Format(Now(),"d") & "')
Bob Filipiak
A question not asked
is a lost opportunity to learn.
----- Original Message -----
From: "Mike Belcher" <[EMAIL PROTECTED]>
To: <[email protected]>
Sent: Thursday, February 10, 2005 6:22 PM
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
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/
