select * from tblDate where Tdate between '01/01/2014' and '31/10/2014'select * from tblDate where Tdate between '2014-01-01' and '2014-10-31'select * from tblDate where Tdate >='2014-01-01' and Tdate <='2014-10-31'

Name : Dotnet Developer-2015Email Id : kumaraspcode2009@gmail.com

'Not by might nor by power, but by my Spirit,' says the LORD Almighty.

Hai Ayesha,You can use the simple select statement which will have either between or >= and <= as the conditions between the FromDate and ToDate.And if you have the date range and you want to get which month data is missing, then you need to use CTE(Common Table Expressions) where you will have the pass the end date and then it will find-out the months where the records are missing.Let's say in the year 2015, you want to get which month data is missing then you can use the below query:

How you are storing the data in the database as String / Date? How you are retrieve the data from the database String / Date ? Following are some the tips you can check.1. If you are storing the data as date format then there is no issue you will get proper data.2. Check the date format in the storing part and also retrieving part.3. If you are storing the date as string. you have to "CAST" or "Covert" in the retrieving part.4. You can use the DATEPART in the retrieve section of the date and compare and concatenate.By NathanDirection is important than speed

The push() method adds new items to the end of an array, and returns the new length.Note: The new item(s) will be added at the end of the array.Note: This method changes the length of the array.Tip: To add items at the beginning of an array, use the unshift() method.ThanksKoolprasd2003Editor, DotNetSpider MVMMicrosoft MVP 2014 [ASP.NET/IIS]