strSQLstring = "SELECT * FROM tblNews WHERE Newsdate = between
DateAdd(""d"",-30,Date()) And Date()ORDER by NewsDate DESC"
I did that and here is the error. Probably something simple.
Syntax error (missing operator) in query expression 'Newsdate = between
DateAdd("d",-30,Date()) And Date()'.
-----Original Message-----
From: Peter Brunone [mailto:[EMAIL PROTECTED]
Sent: Tuesday, February 15, 2005 11:34 PM
To: [email protected]
Subject: RE: [AspNetAnyQuestionIsOk] strSQLstring = "SELECT * FROM tblNews
WHERE Newsdate = between date30daysago and datenow ORDER by NewsDate DESC"
Yeah, whenever that happens, *please* post the error messages so
we can help.
BTW, I messed up the string below; it should look like this:
"SELECT * FROM tblNews WHERE Newsdate = between
DateAdd(""d"",-30,Date()) And Date()
ORDER by NewsDate DESC"
Note the doubled double quotes to escape them from the
already-double-quoted string...
-----Original Message-----
From: Mike Belcher
[mailto:[EMAIL PROTECTED]
I did but when I put them into the aspx page they give errors and it
won't compile. I forget what the errors are will have to go make em
appear again.
-----Original Message-----
From: Peter Brunone [mailto:[EMAIL PROTECTED]
Assuming this is in Access why didn't you just use the Jet SQL
(Access-specific) functions I posted?
"SELECT * FROM tblNews WHERE Newsdate = between
DateAdd("d",-30,Date()) And Date()
ORDER by NewsDate DESC"
-----Original Message-----
From: Mike Belcher
[mailto:[EMAIL PROTECTED]
I tired those and some other combinations and it didn't work. In asp.net
how can get this sql string to do what it says.
"SELECT * FROM tblNews WHERE Newsdate = between date30daysago and
datenow ORDER by NewsDate DESC"
Im still looking for something on the net but if you pros have a way to
take the current date and - 30 from it that would be great.
I
-----Original Message-----
From: Mike Belcher
[mailto:[EMAIL PROTECTED]
Well I am not to familiar with the date functions. I just got home and
will try some of the things that were suggested. Any other suggestions
are welcome :)
Mike Belcher
-----Original Message-----
From: Ali Husain [mailto:[EMAIL PROTECTED]
Why don't you use the built in VB Function DateDiff ()
Ali
-----Original Message-----
From: Peter Brunone [mailto:[EMAIL PROTECTED]
Almost right. I did a quick tour through the date functions and
found that DateAdd works (just like in VBA). Your where clause would
look ike this:
WHERE (((tblNews.NewsDate) Between DateAdd("d",-30,Date()) And Date()
Cheers,
Peter
-----Original Message-----
From: Mike Belcher
[mailto:[EMAIL PROTECTED]
Wow great idea. I did the query in access and then open the SQL view and
here is the string.
SELECT tblNews.NewsDate, tblNews.Headline, tblNews.News,
tblNews.Signature
FROM tblNews
WHERE (((tblNews.NewsDate) Between #1/10/2005# And #2/10/2005#));
Now all I need is to replace the between dates with 2 variables that are
the strCurrentDate amd strDate30DaysAgo and it should work. That is the
last part to figure out.
strCurrentDate = Date
strDate30DaysAgo = Date - 30 // is this right?
DOES THIS LOOK CORRECT?
SELECT tblNews.NewsDate, tblNews.Headline, tblNews.News,
tblNews.Signature
FROM tblNews
WHERE (((tblNews.NewsDate) Between & "#" & '"strDate30DaysAgo"' & "#"
And "#" $ '"strCurrentDate"' % "#" & ));
-----Original Message-----
From: Peter Brunone [mailto:[EMAIL PROTECTED]
I haven't checked into this, but have you tried the Help docs in
Access?
From: "Mike Belcher" [EMAIL PROTECTED]
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]
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"
> 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...
Yahoo! Groups Sponsor
ADVERTISEMENT
<http://us.ard.yahoo.com/SIG=129g12phf/M=298184.6018725.7038619.3001176/
D=groups/S=1705006764:HM/EXP=1108255048/A=2532114/R=2/SIG=12k9jrm2q/*htt
p:/clk.atdmt.com/NFX/go/yhxxxnfx0020000014nfx/direct/01/&time=1108168648
716070>
<http://view.atdmt.com/NFX/view/yhxxxnfx0020000014nfx/direct/01/&time=11
08168648716070>
<http://us.adserver.yahoo.com/l?M=298184.6018725.7038619.3001176/D=group
s/S=:HM/A=2532114/rand=822844874>
_____
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]
<mailto:[EMAIL PROTECTED]
cribe>
* Your use of Yahoo! Groups is subject to the Yahoo! Terms of
<http://docs.yahoo.com/info/terms/> Service.
[Non-text portions of this message have been removed]
Yahoo! Groups Links
Yahoo! Groups Links
Yahoo! Groups Links
Yahoo! Groups Links
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/
