Question from a sql newbie using TSM 3.7.2 The following works (activity log of previous day): select * from adsm.actlog where - (cast((current_timestamp-date_time)day as - decimal(18,0))=0) The following NOT (events from previous day): select * from events where - (cast((current_timestamp-scheduled_start)day as - decimal(18,0))=0) This only gives events of the current day ????? WHY ? and how to make it work ?? Anyone having the answer(s) ???? Tnx in advance Xavier Merlin
