date range

[Guest]

How do I capture records that include the last 12 months? Thanks for your
help.

 

[fredg]

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()

 

[Joseph Meehan]

How do I capture records that include the last 12 months? Thanks for
your help.

What have you tried and what were the results?

Note: often Access likes to see dates as #7/20/2004# so it knows the number
is a date.

 

[Guest]

Hi,

This is what worked for me:

Between #StartDate# and #EndDate#

Diana