XML dateformat

[sigster]

Hi

I am try to format the date so I only see the date
Like 18-07-2012

I get this error

java.text.ParseException: Unparseable date: "2012-07-18T10:46:36" (at offset 4)

<dagsetning>2012-07-18T10:46:36</dagsetning>

         Else If Name = "dagsetning" Then
         
            Dim data As Long
            data = DateTime.DateParse(Text.ToString) 
            'DateTime.DateFormat = "yyyy-MM-dd"
            DateTime.DateFormat ="MM/dd/yyyy"
            Dim DateString As String
            dagsetning_titill = DateTime.date(data)

           End If

Regards
Sigster

 

[corwin42]

For parsing a datestring you have to set the correct dateformat:

Dim data As Long
Dim datestring as String

DateTime.DateFormat = "yyyy-MM-dd'T'HH:mm:ss"
data = DateTime.DateParse(Text.ToString) 

DateTime.DateFormat = "yyyy-MM-dd"
datestring = DateTime.date(data)

 

[Erel]

Here:

Sub Activity_Create(FirstTime As Boolean)
   Log(ParseDate("2012-07-18T10:46:36"))
End Sub

Sub ParseDate(s As String) As String
   DateTime.DateFormat = "yyyy-MM-dd"
   Dim data As Long
   data = DateTime.DateParse(s)
   DateTime.DateFormat = "MM/dd/yyyy"
   Return DateTime.Date(data)
End Sub

 

[sigster]

Thanks corwin42 Erel

this is what I was doing
this is the currency list I was reading online "xml" and I add the image from DirAssets

Regards
Sigster

 

[wizard699]

Do yuo resolve the problem?

 

[Erel]

This is an old thread. Please start a new thread for your question.