Android Question MS SQL DateTime on ScrollView

[Stephenz43]

I am having a difficulty with the formatting of a column in a scrollview. The column in retrieved from a MS SQL database as follows :

row(3) = n.Get("dateShipped")

instead of a date I am getting /Date(12315ect

How should I be formating to just get 04/15/2013

 

[Erel]

What is the value of Log(n.Get("dateShipped")) ?

 

[Stephenz43]

The value retrieved from the sql Server database should be a date like '05/16/2013' . I'm getting /Date(1377586800000)/

 

[Stephenz43]

the value of Log(n.Get("dateShipped")) is /Date(1377586800000)/

 

[Erel]

What you are seeing is the value returned from the server. You will need to parse it. The numeric value seems like the correct ticks value:

Log(DateTime.Date(1377586800000))

 

[Stephenz43]

so , what about the prefix( /d(xxxxxxxxxx)/ doe the /d( and )/ need to be parced out.

 

[wl]

You could also consider having SQL convert the date and return it as a string/varchar:

select convert(varchar(10), dateShipped, 101), ...

Also see: http://technet.microsoft.com/en-us/library/ms187928.aspx

 

[Mahares]

Hopefully wl's previous post is what you are looking for. If not, here is a way to parse the string:

Dim MyDate As String = "/Date(1377586800000)/"
MyDate=MyDate.Substring2(MyDate.indexof("(")+1, MyDate.indexof(")")) 'returns 1377586800000
Msgbox(DateTime.Date(MyDate),"") 'displays 08/27/2013