Create a Report on all Normal Changes planned for Mon-Fri 5AM ET and 6PM ET.

[Leon Els]

Greetings! 
-Vancouver Release-
I am trying to report on all approved Normal changes planned for implementation between Mon-Fri 5AM ET and 6PM ET.

By looking at Table: [change_request] 
And Field: "Planned Start Date" 

Spinning my wheels at this point 😉 
Appreciate any guidance to see if this is possible.

Thank you!
Leon

[Dr Atul G- LNG · Accepted solution]

Hi @Leon Els 

Tried this:

[Slava Savitsky]

You should use "on or after" for the "5 am hour" condition. "5 am hour" means the time span between 05:00:00 and 05:59:59. Your current condition "after 5 am hour" is interpreted by the system as after 05:59:59.

[Dr Atul G- LNG]

Thanks @Slava Savitsky 

Yes, all conditions must be on or after / on or before. 

[Slava Savitsky]

Not all. If the time span to cover is from 05:00:00 till 17:59:59 (at least this is how I understand the question), then the conditions should be "on or after 5 am hour" and "before 6 pm hour".