View Full Version : Date Ranges in Reports


dazzmondo
08-23-2005, 06:57 AM
Hello all, this is probably simple but im new to all this!

I am trying to produce reports that show details for only the past year, at present my reports are bringing up details of all the previous years also. Is there any way you can put conditions on reports ( or should it be in a query) that tells the report to only include dates i.e. today - 365 days. At present i have to change the dates every day both a start and end date. Is this possible?

Thanks :eek:

Rich
08-23-2005, 09:31 AM
Between Date() And DateAdd("YY"-1,Date()) in the criteria for your date field