Access Date Query

September 30, 2009 at 07:15:51
Specs: Windows Vista

I need a query that will only show dates between the date in the date column and the date exactly a year before it.

eg: 30/09/09 and 30/09/08

is it possible to do this?

See More: Access Date Query

January 21, 2010 at 11:21:32

>=[Table].[Column]-365 And <=[Table].[Column]

in the criteria box of the field you want sorted with
Table and Column being the table and column of your date field you want to do the year reference from.


FROM Table
WHERE (((Table.DateColumn2)>=[Table].[DateColumn1]-365 And (Table.DateColumn2)<=[Table].DateColumn1]));

Hope that is what you were looking for.

Report •
Related Solutions

Ask Question