SQL to return information with dates between now and 2 months

shaz0503
shaz0503 used Ask the Experts™
on
All

I can't seem to get a query to return the required values

i need a query to return information with dates in tblStatementDetails.[SoE review date] between now and two months from now....

rgds

shaz0503
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Top Expert 2010
Commented:
Depending on what you mean by "now"...
SELECT *
FROM tblStatementDetails
WHERE [SoE review date] Between Date() And DateAdd("m", 2, Date())

Open in new window

Author

Commented:
Thanks heaps

It is always obvious when you see the solution.

rgds

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial