Ok here is an idea in the sql statment select * from your table name where reviewdate between date() and date-30 but try to detect my sql statement , hope it works Good Luck Thanks 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!? Yahoo! Mail Address AutoComplete - You start. We finish. [Non-text portions of this message have been removed] ------------------------ 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/
