Previous 12 months

[IanT]

Between DateSerial(Year(Date()),Month(Date())-1,1) And DateSerial(Year(Date()),Month(Date()),0)

I am using the above to select the preceding 12 months data, but it does not show the current months details, can this be adapted to do this!

 

[simongallop]

How about >DateAdd("m",-12,Date())?

 

[ColinEssex]

or perhaps

Between Now()-365 and Now()

Col

 

[Ken Grubb]

Between DateSerial(Year(Date())-1,Month(Date()),Day(Date())) And Now()

[This message has been edited by Ken Grubb (edited 03-20-2002).]