Getting A Specific Date

I'm then going to use the answers in my select statement to pull data from the database.

Heres what i have now:
sql= "select * from assistancerequest where datein >= Date() - 7"

heres the problem with it:
it gives no errors but when it shows my output it shows wrong data.

Example:
27/08/04
28/09/04
28/09/04
29/09/04

this is some of what i get. as you can see it counts back 7 days, but its not working because this is from two different months! so it looks like its only checking for the days and not the month. does any of this make sense?