VB.Net - SQL Server Geting Certain Date Values from DateTime Field
Posted on 2015-01-12
Good Day Experts!
I am having trouble with an item and have tried the net searching to no avail.
In my SQL table I have a value like 10/28/2014 10:09:23 PM. The field is defined as DateTime. In the VB.Net program, the User will enter a start and end date 10/28/2014 to 10/29/2014. I have been unable to figure out this out. I have tried Date conversions and Left to try and get the first 10 characters before the time.
Do you have any helpful suggestions?