Dynamic Date Range-help with SQL???
Content
Hello all, I could use a hand. I am trying to write a report that shows us all the reqs posted in the last 24 hours and we plan to run this each business day. This works great Tuesday, Wednesday, Thursday, and Friday. Mondays it doesn't. On Mondays the report is only looking back 24 hours (to Sunday) and it really needs to look back from the last time the report ran (Friday). I am ok having two different reports since the T-F report works. Now, to fix the Monday report. I am specifically looking at the posting date associated