Selecting records from the current AND prior year

[JuanRa]

I am trying to build a report where I can compare the records from a day this year to the same day last year.  

 

[MalcolmW]

To find the same day in a previous year, then <br>Date((Year(Today) - 1),Month(Today),Day(Today)) will normally work, where Today can be replaced by any date value.&nbsp;&nbsp;However, if the date value is Feb 29, then this formula will result in an invalid date, so you have to decide how you are going to deal with that exception. <p>Malcolm Wynden<br><a href=mailto:wynden@island.dot.net>wynden@island.dot.net</a><br><a href= > </a><br>