You can filter dates like following
SELECT ID.Text,ValidFrom,ValidTo
FROM [YourTableName]
WHERE ValidFrom BETWEEN '02/04/2015' AND '02/06/2015'
But, this will definitely not give the result as you have shown because as you want result like
ID Text ValidFrom ValidTo
2 A 2/3/2015 2/7/2015
3 C 2/5/2015 2/6/2015
but '2/3/2015' or '2/7/2015' of first row doesn't match with filter date range '02/04/2015' and '02/06/2015'
If you want something else, please let me know :)