Jimbo99999
asked on
VB.Net - SQL Server Geting Certain Date Values from DateTime Field
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?
Thanks,
jimbo99999
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?
Thanks,
jimbo99999
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Regional settings from client and server machines may be different. Also, what's the SQL Server instance's collation?
ASKER
JimHorn:
I apologize for not being complete in my description. I have From and To textboxes on this screen as many others.
How do I pass them as datetime for use in my query?
Ste5an:
I have never tried it the way you have suggested. Here is what I normally do. The [Process Week] field does not have the time after it like the field causing me grief.
cmdGetRecordsString = "Select * FROM [Invoicing] " & _
"Where [Process Week] >= '" & txtStartDateAud.Text.Trim & "' and [Process Week] <= '" & txtEndDateAud.Text.Trim & "' "
cmdGetRecords = New SqlCommand(cmdGetRecordsSt ring, SQLConnectAccount)
Dim rdrGetRecords As SqlDataReader = cmdGetRecords.ExecuteReade r
I apologize for not being complete in my description. I have From and To textboxes on this screen as many others.
How do I pass them as datetime for use in my query?
Ste5an:
I have never tried it the way you have suggested. Here is what I normally do. The [Process Week] field does not have the time after it like the field causing me grief.
cmdGetRecordsString = "Select * FROM [Invoicing] " & _
"Where [Process Week] >= '" & txtStartDateAud.Text.Trim & "' and [Process Week] <= '" & txtEndDateAud.Text.Trim & "' "
cmdGetRecords = New SqlCommand(cmdGetRecordsSt
Dim rdrGetRecords As SqlDataReader = cmdGetRecords.ExecuteReade
Please use parameterized queries. Otherwise you code is also prone to SQL Injection (ignore the ASP specific points, it's the same for WinForms/WPF).
ASKER
Ok, I will try for the first time. I am always up for adding new things to the toolbox of knowledge!
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks for the responses. I had another "little" project that came up in another area. I will hopefully get back to this one Friday or Monday. Thanks for your patience.
In one text box or two? Common practice is to have a 'From' textbox and 'To' textbox, and pass both values as datetime, rather then '10/28/2014 to 10/29/2014' in one textbox and then rely on code to parse the string to extract both dates.