Need help with creating DATE Interval

[erumhyder]

I need to get all the results from my table(opportunities) column called CloseDate. That have a CloseDate falling in any date of the past week including the day I run the query.

I tried this but its not working:

Select Opportunities.*
From Opportunities
Where (Opportunities.Closedate) >=date()-7 AND <=date() ;

[DonRayner]

You should be using the DateDiff() function in your where statement.

[erumhyder]

Thanks for the quick response.For some reason thats not working with the other criterias that i am using but it works with the Between Clause.

[missinglinq]

Something like this:

SELECT Opportunities.*
FROM Opportunities
WHERE (((Opportunities.CloseDate) Between Date()-7 And Date()));

(Opportunities.Closedate) >=date()-7 AND <=date()

isn't valid syntax in Access VBA, it would have to be

(Opportunities.Closedate) >=date()-7 AND (Opportunities.Closedate) <=date()

Welcome to Bytes!

Linq ;0)>

[erumhyder]

Thanks!
It works now.

[missinglinq]

Glad we could help!

Linq ;0)>

[NeoPa]

NB. I would consider making the WHERE clause :

WHERE (((Opportunities.CloseDate) Between Date()-6 And Date()))

I'm guessing you want to cover a period of a single week rather than 8 days, but I may be misinterpreting the question so you see which is required ;)

Welcome to Bytes!