Load date based on predefined Times

[anuradhaa]

Hi,

My script loads every one hour. here i want to load the data with the check on event time and reload time.

ex - I have three predefined hours   

06:30 , 14:30 and 22:30

if my script loads 10:00 AM i want to load all events happen before 06:30 AM

if my script loads 06:00 PM i want to load all events happen before 02:30 PM

if my script loads 11:00 PM i want to load all events happen before 10:30 PM

I take hours as cut off limits.

Please help me to do this

[anuradhaa]

It's not that accurate,

Please find attached for times.

I need to put them to latest 3 shifts,

06:30 - 14:30

14:30 - 22:30

22:30 - 06.30 next day