ADD in a "and date_time>current_timestamp-1 days" Tim Rushforth City of Winnipeg
-----Original Message----- From: David E Ehresman [mailto:[EMAIL PROTECTED]] Sent: Friday, April 05, 2002 9:09 AM To: [EMAIL PROTECTED] Subject: Activity log messages How would I modify the SELECT statement in the TSM supplied sample Q_MSG-SEV script to only return messages from the past 24 hours?