>Okay, I have now managed to create an ADO connection in my ASP and am hooked up to a table. I'm nuot sure of the syntax (VBScript and ADO/SQL) to select all records that have a date within the last 30 days:
>
>

>oRecSet.Open "SELECT * FROM myTable WHERE dt > [confused here, need today's date minus 30 days?]", oConn, 1, 1
>

>
>Any help is greatly appreciated. Thanks a lot!
>jfh

You can use the Between key word.
Example: SELECT * FROM myTable WHERE dt Between vStartdate And vEnddate