Make Chart Show Only 6 Months of Data

[Guest]

I have created a line chart to reflect the total number of transactions that
have occured each month. Over time this chart will become quite lengthy so I
would like to limit the bottom axis to the last 6 months of data. Can't for
the life of me how to make "Between Now And (6 Months Ago)" into criteria.

Thanks!
Meredith

 

[Rick B]

something like...

DateSerial(Year(Date()),Month(Date())-6,Day(Date()))

Rick B