VB.Net - Compare SQL DateField Ignoring Time
Posted on 2014-02-17
Good Day Experts!
I have a bit of an issue that I am trying to work through with regards to a DateTime field in my SQL table. It contains the time after the date.
I give the User a Start Date and and End Date to enter on the UI. I want to retrieve records in the SQL table based on a date field. So, I am "asking" in the SQL query for the date field to be >= StartDate and <= End Date.
How do I get the query to look at the date field without respect to the time on the back of the date?
Thanks for helping,