CA Service Management

Expand all | Collapse all

Next 24 Hours Filter Universe Design Tool

Jump to Best Answer
  • 1.  Next 24 Hours Filter Universe Design Tool

    Posted 07-27-2017 10:09 AM

    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 

     

     

    Thanks,
    Jessie 



  • 2.  Re: Next 24 Hours Filter Universe Design Tool
    Best Answer

    Posted 07-28-2017 10:30 AM

    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