If you can have multiple entries for a single date and you want to have only 2 of those listed, then you should explain what is the criteria for selecting those 2 records from all the possible records for the same date.
To select all records from a table between two dates, you can use BETWEEN. For example
SELECT * FROM TableName WHERE DateColumn BETWEEN @date1 AND @date2