Date Conversion

[genius]

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?

 

[klaus]

    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)

Best regards.

 

[genius]

Thanks