Query to find records from only 6 months ago.

[Rustin788]

Hey,



I am trying to setup a query that will give me the records for 6 months back from the current day and only the records that were in that 6th month. So I guess say a month equals 30 days so I want records from between 181 days ago and 150 days ago. I want to always be that date range so the records should be changing daily. I know there is an option to separate by actual month in a date field but then the numbers will always be off depending on what part of the month it is.

Thanks in advance to anyone that can help me out.

*I will also be doing this for other months but I once the correct formula is implemented I imagine it will be easy to change it to fit the correct range.

[June7]

Try:

SELECT * FROM table WHERE [date field] BETWEEN DateAdd("m",-6,Date()) AND Date();

or

SELECT * FROM table WHERE [date field] BETWEEN Date()-181 AND Date();

or

SELECT * FROM table WHERE [date field] BETWEEN DateAdd("d",-181,Date()) AND Date();

[Rustin788]

Hey,
That gave me blank results. Previously I had:

>=DateAdd("m",-6,Date())

and without the >= I would get blank results as well. I tried inputting the >= into the formula you gave but it did not give any results either.


*Just saw your update I will try those out as well.

**The middle one you posted works but it is pretty much the same thing I posted above and it shows all records from the past 6 months.

[Rustin788]

Ok. I input the criteria below and I believe it is pulling up what I want. Thanks.

[InvoiceDate] Between DateAdd("d",-181,Date()) And DateAdd("d",-150,Date())

[June7]

Glad you figured it out. I missed a couple details of your criteria.