I have never stumbled across a need for something like this so I thought I'd ask you guys for some perspective and help. I have built a report as requested but I'm having trouble figuring out how to make it run for the time frames requested.
The report needs to run from 8am the previous day up to 8am the current day, every day. I am unsure even where to begin to state this or how to go about doing it. I can somewhat picture the logic in my head, something along the lines of CurrentDate -1 or something similar but have no idea as to the proper syntax or placement. If I were to just specify the dates it would look like the following:
12/25/2013 8:00:00am to 12/26//2013 7:59:59am
However, I need it to just run with no user input so I don't think providing input parameters would work in this situation.
To compound the issue I have to use a formula to correct the times that return because, for whatever reason, Crystal sees the data as several hours ahead of time. I have fixed that issue but I have to now use that adjusted time frame as the selection criteria.
Any help you guys can offer would be greatly appreciated.