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