Query to pull past 3 months (1 Viewer)

[kidrobot]

I have a query that I need to always pull data from the newest past 3 months, so if this query were ran today it would take from months 2,3,4 (Feb, Mar, Apr). Any clue on how to do this?

 

[rainman89]

between dateadd("m",-3,date()) and date()

 

[kidrobot]

That didn't work. Does any of that above correspond to a column name?

 

[rainman89]

it should go in the criteria of your date column

 

[kidrobot]

Yes, that is exactly where I placed it.

 

[kidrobot]

I'm not sure if my question was clear, but the months are in the table so I only want the months 2, 3, 4. (that is how the months are displayed in the table also, just as numbers)

 

[rainman89]

i just created a sample query and put this in and it worked.

Between (DateAdd("m",-3,Date())) And Date()

 

[rainman89]

oh.... i see now
then the way i suggested will not work for u

 

[kidrobot]

=( ... do you think it is possible then?

 

[rainman89]

yeah. ull need to search on parsing dates to get the month number then base your query upon that

 

[boblarson]

Then move to this (a variation on Ray's suggestion):

Between Format(DateAdd("m",-3,Date()),"m") And Format(Date(),"m")

 

[kidrobot]

sweet that works great, for some reason it pulls data from 2,3,4,5. So I just used 2 and it took 2,3,4. Thanks!~

 

[kidrobot]

Sorry but my Manger wants the past 3 months not including the current month.

This Between Format(DateAdd("m",-2,Date()),"m") And Format(Date(),"m") ... works but it takes 3 months plus the current month, any idea on how to skip the current month?

 

[boblarson]

Between Format(DateAdd("m",-2,Date()),"m") And Format(DateAdd("m",-1,Date(),"m")

 

[kidrobot]

wow you're amazing... i gave you positive replutation points