# Query Help: select certain time window over 2 days

**URL:** <https://forum.inductiveautomation.com/t/query-help-select-certain-time-window-over-2-days/19836>\
**Category:** Ignition\
**Created:** [September 26, 2018, 2:40pm UTC](https://forum.inductiveautomation.com/t/query-help-select-certain-time-window-over-2-days/19836 "2018-09-26T14:40:47Z")\
**Posts on this page:** 1\
**Showing post:** 6

<div class="post-metadata">

**Author:** ![dkhayes117](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/dkhayes117/32/68344_2.png) [@dkhayes117](https://forum.inductiveautomation.com/u/dkhayes117)\
**Post date:** [February 15, 2022, 7:50pm UTC](https://forum.inductiveautomation.com/t/query-help-select-certain-time-window-over-2-days/19836/6 "2022-02-15T19:50:44Z")

</div>

I use the built in ignition schedules to determine the shift start and end times. I have a gateway timer script that writes to `shift active` boolean tags. [Shift Work Schedules - Ignition - Inductive Automation Forum](https://forum.inductiveautomation.com/t/shift-work-schedules/19848/10)

---

_[View the full topic](https://forum.inductiveautomation.com/t/query-help-select-certain-time-window-over-2-days/19836)._