I am struggling to capture a filter for the "Next 24 Hours" to report on changes scheduled from the time the report runs at 8am until it runs the next day (so anything scheduled from 8AM-7:59AM the next day). I have tried the pdmtoday and it is capturing full days (as I understand it should). This report needs to have the filter because it needs to be automated.I have researched the document below and others.
Everything you need know about CA Service Desk Date format
I found this article https://communities.ca.com/thread/241762745-pdmtoday-adjust-to-the-middle-of-the-day
and did BETWEEN pdmtoday(-1)+28800 and pdmtoday(1)+28800 and it worked