Hi Experts. I currently enter a date into a textbox with this
Textbox1.Text = Now.ToLongDateString
I then save this to a SQLCE Database as text which saves like this
08 February 2015
When I call the text back from the database with this
Dim DateFromDB As DateTime = DateTime.Parse(DBString(3))
I get the date as this
I then use the dates like this
If DateFromDB.Date >= StartDate.Date And DateFromDB.Date <= EndDate.Date Then
This seems to work correctly on some clients but not at all on others.
I suspect it has to do with the date format on the client.
Does VB.Net not automatically allow or compensate for different date formats like this. Am I supposed to convert to a standard format?
Any help would be appreciated.