>>
>>You can use the Between key word.
>>Example: SELECT * FROM myTable WHERE dt Between vStartdate And vEnddate
>
>Tim,
> Thanks for giving me more credit then is due < g >. Maybe I should have phrased that differently. My VBscript skills are almost non-existant. How do I return todays date, and the date 30 days ago?
>jfh

Take a look at the Date function.

Todays date: Date()
Date 30 days ago: Date() - 30