How do I capture records that include the last 12 months? Thanks for your
help.
For records between 7/20/2004 and 7/20/2005 (today's date)
Between DateAdd("m",-12,Date()) and Date()
For records between 7/1/2004 and 6/30/2005 (the last day of the
previous month)
Between DateSerial(Year(Date())-1,Month(Date()),1) and
DateSerial(Year(Date()),Month(Date()),0)
For records from 7/1/2004 through 7/20/2005
Between DateSerial(Year(Date())-1,Month(Date()),1) and Date()
