2 Replies Latest reply on Aug 15, 2013 1:42 PM by Aishwarya Balamukundan

    Custom Sql- where condition for Date working incorrectly

    Aishwarya Balamukundan

      Hi All,

       

      I m trying to write an SQL that will return the count of the records given that it falls in a certain range of date:

       

      Select Count([S].[Date])

      from [Sheet1$] as [S]

      where [S].[Date]>5/1/2013

       

      Its a simple SQL but Somehow it is returning to me the total number of rows and the where condition is not working.

       

      What I actually need is count of the records when the date lies between say 5/1/2013 and 7/31/2013. I tries to put this condition but it failed. Any help on this is really appreciated.