I am trying to figure out how to write a Openedge query where i can look back 4 hours. i have struggled with the TIME syntax before. If i understand correctly, the TIME representation in Openedge is in seconds starting from midnight. The query i am trying to write would run 4 times a day, looking back 4 hours. Is there any way to do this using TIME? Maybe i have to write 4 different queries that only pull records starting at a specific time? Thanks very much for any help i can get, it is greatly appreciated! Martin Continue reading...