Time specific graphs

[legendv]

Hello all! Knowing that Access isn't the greatest at handling graphs, I have what I want so far... well mostly. My Problem is that I want the graph to view only the current years data. More specificly, today -364.
The date is a field in the query, yet when I try to define the time frame as criteria <Date()-365 it still pulls all info into the graph.
Is this a problem with A2K graphs or me? I'm sure the later, but does anyone have suggestions for me?

 

[Rich]

>Date()-365

 

[The_Doc_Man]

Or try criterion

< DateAdd( "yyyy", -1, [datevalue]) 'for date from a table

or

< DateAdd( "yyyy", -1, Date()) 'for date from today

or

< DateAdd( "yyyy", -1, "# dd-mmm-yyyy #" ) 'for constant date

 

[Rich]

Surely it's >DateAdd("yyyy",-1,Date()) to return the past years data

 

[legendv]

Thanks for all your help. Its working just fine now. Last question on graphs. Is it possible to place benchmark data at the begining of the graph to compare against the db's data?