Display Last 10 days worth of records

[drewangell]

I've got a simple DB with requests table and a field called Shipped that is a
check box. Yes/no whether it's been shipped. I'd like to create a page which
shows me all shipped items for the last 10 days. I'm having trouble coming up
the SQL that it takes to do this though.

Any information would be greatly appreciated. Thanks!

Drew

[darrel]

> I've got a simple DB with requests table and a field called Shipped that
is a

> check box. Yes/no whether it's been shipped. I'd like to create a page

which

> shows me all shipped items for the last 10 days. I'm having trouble

coming up

> the SQL that it takes to do this though.

Something like:

SELECT items WHERE (shipped = true) AND (shipDate > (GETDATE ( ) - 10))
ORDER BY shipDate desc

Not sure if the mat equation will work within the SQL statement, you might
have to do that part outside of the SQL query.

-Darrel