The problem is when selecting from events table it's by default generated with the information of todays date only. Using (CURRENT_TIMESTAMP-SCHEDULED_START<'2 00:00:00') will get information less than two days old within todays info. See the problem? However if you specify a specific date (i.e. '2003-10-25') the events table will be generated from this. There's no limitation in SQL saying you can't use both a specific date and CURRENT_TIMESTAMP at the samt time. I spent hours figuring this out and note that the following workaround will only work for less than 200 years...
SELECT * FROM EVENTS WHERE SCHEDULED_START BETWEEN '1970-01-01' AND '2199-12-31' AND CURRENT_TIMESTAMP-SCHEDULED_START<'2 00:00:00' regards, Anders Pontusson
