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 <*> 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/
