16 Replies Latest reply: Nov 17, 2014 7:57 AM by Ali Hijazi RSS

    SQL don't select date range

      How would I adapt the following script to exclude rows where the SessionStartedDate was in the range 2014-11-03 and 2014-11-09?

       

       

      QUALIFY *;

      UNQUALIFY SessionStartedDate;

      DaySummary:

      LOAD

          Date(DayStart(Date(Date,'DD/MM/YYYY')),'YYYY-MM-DD') As SessionStartedDate,

        Users,

        Disconnects,

        Reconnects,

        WorkingDayDisconnects,

        WorkingDayReconnects;

      SQL Execute [dbo].[DaySummary];

       

      UNQUALIFY *;