Hi, when I retrieve a record from sqlite which its datatype is Date, it will show as "2011-11-27" and I want to show it as "11/27/2011". Is there a way to convert it?
Dim DateTick As Long
Dim DateStr As String
DateTime.DateFormat="yyyy-MM-dd"
DateTick = DateTime.DateParse("2011-11-27")
DateTime.DateFormat="dd/MM/yyyy"
DateStr = DateTime.Date(DateTick)