I am trying to create a code set that will tell me how old reports are. For example. I have a field in the ACCESS db that is "report_date" and is a date/time. I want to break the reports down by
1. Less than 24 hours
2. 24-48 hours
3. 3-7 days
4. 7+ days
I know I can use datecompare, but I am having trouble with the less than 24 hours and the 24-48 hours part.
How can I take report_date < 24 hours and cull those records from the query and report_date between 24-48 hours with a date.