I have a web app developed in Visual Studio (vb.net) that ties to a SQL Server database. One of the fields in the database is a datetime field. The form has two text boxes, txtDate, and txtTime. txtDate takes a regular expression along standard m/d/yyyy format (e.g., "1/1/2007", "12/13/2007"). txtTime takes a regular expression along standard time notation (e.g., "5:00 PM", "12:00 PM", "4:21 PM").
I need to convert these two separate strings into a datetime object so I can store it in the database.
I know this sounds simple, but I've been having a ton of problems with dates, times, datetime, and timespans. It's not quite intuitive.