I'm putting together a retail comp report that compares the current day stats to the same day, previous year. Is there a code I can use to get last year, same day?
For example: This year stats= 7/22/2007-Sunday
Previous year= 7/23/2006-Sunday
I need to be able to put this string into the design view in a criteria field. For Calendar comp I use the following.
This year: >=DateSerial(Year(Date()),Month(Date()),1) And <=Date()-1
Last year:>=DateSerial(Year(Date())-1,Month(Date()),1) And <=Date()-366
Can this be done for same day is what I'm wondering? Any help would be greatly appreciative.
I'm currently running Windows XP Pro SP1 and MS Access 2000