Closed peter-mount closed 8 years ago
Confirmed as I manually ran the procs affected (also #48 ) at 00:00 and they worked.
Now fixed. As this is always called for an entire hour, eg: 23:00-00:00 the search has been tweaked so that it looks for departures within the next 59 minutes 59 seconds instead of 1 hour. a hack but a valid one for this.
Performing a search for 22:59 will return results but none for 23:00.
Looking at it, this is down to the query running between 23:00 & 23:00+1hour which is 00:00 so the search range is invalid.
The proc needs to be aware of midnight.