My mistake....try this:
        tsm: ADSM>select * from events where
days(current_timestamp)-days(scheduled_start)<1

        SCHEDULED_START: 2001-01-05 00:30:00.000000
           ACTUAL_START: 2001-01-05 00:30:24.000000
            DOMAIN_NAME:
          SCHEDULE_NAME: BACKUP_DEVCONFIG_3
              NODE_NAME:
                 STATUS: Completed
                 RESULT: 0
                 REASON: Ok




        Joseph Marchesani <Joseph.Marchesani AT AXACS DOT COM>
        01/05/2001 08:39 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 events

        Adsm Group

        In a previous Email from Jim Healy to the group,  it was suggested
to use
        the following WHERE statement: to get the prior day events.

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

        The varibles DAYS, CURRENT_TIMESTAMP, & DATE_TIME are not part of
the
        EVENTS table is there another table that has to be JOINED to the
events
        table
        to get the above variables.

        I am using the Microsoft Excel ODBC query to get the event
information.


        Thanks

        Joe Marchesani


        t---------------------- Forwarded by Joseph M
Marchesani/NYM/Equitable on
        01/03/2001 03:13 PM ---------------------------

        James J Healy
        12/29/2000 11:50 AM


        To:   Joseph M Marchesani/NYM/Equitable@AXA-Equitable
        cc:

        Subject:  Re: SQL query for events


        ---------------------- Forwarded by James J Healy/NYM/Equitable on
        12/29/2000 11:49 AM ---------------------------


        "Williams, Tim" <Tim.Williams AT FRITOLAY DOT COM>@VM.MARIST.EDU> on
12/29/2000
        11:38:32 AM

        Please respond to "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT 
EDU>

        Sent by:  "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>


        To:   ADSM-L AT VM.MARIST DOT EDU
        cc:

        Subject:  Re: SQL query for events


                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?