Help - SQL query for date

[lindaklu]

I'm using ASP and SQL for my progress database. I want to display orders within the last 7 days (from today's date). I try the DateAdd function in VBScript but it errors: Unable to understand after DateAdd. I'm not sure if Progress recognizes this DateAdd function or is there something wrong with the syntax. Below is an ex. of my code, please advice!

str="Select item, description From ItemTable Where orderdate >= DateAdd('d',-7,today) "

 

[mnewnham]

First off, shouldn't you be using DateAdd('d',-7,now) rather than 'today'?