Try changing your sql Statement with DateDiff("d",
[date()], [reviewdate])in the where class of the SQL
statment.
Cheers
mani
--- Hany Reyad <[EMAIL PROTECTED]> wrote:
> Ok try to change your sql statement to
> select * from your table name where reviewdate
> between date () and date () - 30
> or try to search builder.com site to see more about
> using where condition using in sql statement
> wish it works
> Good luck
> Hany Reyad
>
> shawnyharrison <[EMAIL PROTECTED]> wrote:
> Hi all,
>
> I am using asp (VBScript) to display data from an
> Access 2000
> database. The problem
> I have is that I need asp to display ony the records
> that are older
> than 30 days based on a recordset field called
> ReviewDate. This
> field is formatted in medium date format in Access
> before it gets to
> my recordset in ASP.
>
> Any help would be great,
>
> Shawn Harrison
>
>
>
>
> Yahoo! Groups SponsorADVERTISEMENT
>
>
> ---------------------------------
> Yahoo! Groups Links
>
> To visit your group on the web, go to:
>
http://groups.yahoo.com/group/AspClassicAnyQuestionIsOk/
>
> To unsubscribe from this group, send an email to:
>
[EMAIL PROTECTED]
>
> Your use of Yahoo! Groups is subject to the
> Yahoo! Terms of Service.
>
>
>
> ---------------------------------
> Do you Yahoo!?
> New and Improved Yahoo! Mail - Send 10MB messages!
>
> [Non-text portions of this message have been
> removed]
>
>
>
> ------------------------ Yahoo! Groups Sponsor
> --------------------~-->
> Yahoo! Domains - Claim yours for only $14.70
>
http://us.click.yahoo.com/Z1wmxD/DREIAA/yQLSAA/saFolB/TM
>
--------------------------------------------------------------------~->
>
>
>
> Yahoo! Groups Links
>
>
http://groups.yahoo.com/group/AspClassicAnyQuestionIsOk/
>
>
>
[EMAIL PROTECTED]
>
>
>
>
__________________________________
Do you Yahoo!?
New and Improved Yahoo! Mail - 100MB free storage!
http://promotions.yahoo.com/new_mail
------------------------ Yahoo! Groups Sponsor --------------------~-->
Make a clean sweep of pop-up ads. Yahoo! Companion Toolbar.
Now with Pop-Up Blocker. Get it for free!
http://us.click.yahoo.com/L5YrjA/eSIIAA/yQLSAA/saFolB/TM
--------------------------------------------------------------------~->
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/AspClassicAnyQuestionIsOk/
<*> 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/
