I wanted to get all of the rows that were time stamped today from a table that has a datetime column.
Here is the query that I used:
SELECT COUNT(*) AS [Today's File Count] FROM dbo.Envelope WHERE (CONVERT(varchar, entry, 101) = CONVERT(varchar, GETDATE(), 101))