Date Range Problem

[Darrell Wootton]

Hi,

I have been looking for a way to get a date range I need.

IIF([Period]Between DLookup("[DateFrom]","Period") And DLookup ("[DateTo]","Period"),[Advance],0)

This currently returns data on the following period "01/01/2004" to "01/05/2004"

This part works fine.

In the same query I need to create a new column and retrieve data for the same period 12 months earlier.

Is there a way to use the above code and tell it to use 2003 instead of 2004.
ie:

"01/01/2003" to "01/05/2003"

Thanks in advance.

Darrell......

 

[namliam]

use dateadd...

try either ?dateadd("m",-12,date())
or ?dateadd("yyyy",-1,date())

This will however take into account the leapyear...

Regards