try adding
        where days(current_timestamp)-days(date_time)<1
        to your select statement...




        "<James> <healy>" <James.Healy2 AT AXACS DOT COM>
        12/29/2000 09:34 AM
        Please respond to "ADSM: Dist Stor Manager"
<ADSM-L AT VM.MARIST DOT EDU>@SMTP@Exchange
        To:     ADSM-L AT VM.MARIST DOT EDU@SMTP@Exchange
        cc:

        Subject:        SQL query for events

        Can anyone help with the sql query I could use to see events that
occurred
        form yesterday to today?