XML Time format to English Time Format??

[fahadbht]

Hello all

I am getting the XML feed and displaying it for every record in Flash, the time format in XML is :

<Date>2009-03-22T00:00:00.0000000-00:00</Date>
<Time>1900-01-01T20:00:00.0000000-00:00</Time>

How to convert that into e.g: 22 March 2009 and 19:00, before displaying it into the dynamic Text Box?

any help or support will be much appreciated

Thanks
Fahad

[MyFriendIsATaco]

That format is extremely weird. The time and date are supposed to be in one object.

For example, for 22 March 2009 @ 19:00, Date should be:

<Date>2009-03-22T19:00:00.0000000</Date>

It doesn't make sense to have it split into two parts like that, because in the <Time> tag, what does: 1900-01-01 mean? That's supposed to be a date. Time isn't displayed in that format. Then in the Time part again, what is the: 20:00:00.00000?

You have something weird going on here.

[fahadbht]

Thanks for replying MFIAT, I spoke to the developer and he says that this is the system generated time format in XML, maybe we need to trim it a little bit before putting it onto flash text boxes.

[MyFriendIsATaco]

It's not that it needs trimmed, it's just that it's wrong. That format is used for a very specific date and time down to the fractions of a second.

Your date is in part of the format, then the time is used in the wrong place in that format resulting in at best, to the minute accuracy. Your "19:00" is taking the place of the year in the format. Totally wrong.