I have a 'DatePlayed' field stored in a SQLite database that is saved as a String type. I am retrieving this field through a query in order to update another field called 'SQLDatePlayed' that stores the same date value but as a Date type (With format 2013-08-28). I am using the code below to try and parse the string field, but am getting the error 'java.text.ParseException: Unparseable date: "28 Aug 2013"' (at offset 2).
Any suggestions?
Dim TheDate As String
TheDate = Cursor.GetString("DatePlayed")
DateTime.DateFormat = "yyyy-MM-dd"
Dim t As Long = DateTime.DateParse(TheDate) 'Error occurs here