Web Development

Ask something
Question Locked

Query - Last 6 months

0 helpful
2 replies

by n.smith326

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Greetings,

I need help w/ a query. Ideally I would like to pull all records from two tables for the previous 6 months. I have considered using a parameter query, but it would be better if it could be automated.

Any help would be greatly appreciated.

Thanks,

Natalie

2 replies

by bschaettle

Here's the basic concept:

WHERE (
(datediff("d",mydate,getdate()) <=182)
AND
(datediff("d",mydate,getdate()) >=0)
)

This discussion is closed to new replies.