I want to show data between a certain time period.
The timestamps are below :
TIMESTAMP([TSA_ROUTE_DEP_1],'YYYY/MM/DD hh:mm:ss') AS TIMESTAMP,
Example
2016/22/06 10:00:00
I built a filter into a button using a search function like (9|10|11|12|13|14|15|16|17|18|19|20|21)
and another button to filter out night times (21|22|23|00|01|02|03|04|05|06|07|08|09)
Reason being, that i want to show data for 2 different shifts. Dayshift (09:00 to 21:00) and Nightshift (21:00-09:00)
However, the date becomes problematic, as a shift starts for example at 22.06.2016 at 21:00 and ends at 23.06.2016 09:00. Thus my button searches does not take into account the date change after midnight.
Can anyone make a suggestion as to how i could filter out times between two timestamps.
Identifying day and night is not the problem. the problem is that dayshift will filter out fine, however, during nightshift - the data includes day and night times because of the 12 hr time period.
So i need nightshift to include the next days data up until 9am in the morning.
for example :
22.06.2016 21:00 until 23.06.2016 09:00 because the new day starts midnight.
