XML Time format to English Time Format??

Hello all

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

Quote:

---

<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

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.

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.

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.