Convert External XML Timestamp to Readable HTML Display with JScript

**sinsysonline** · 12-13-2012 02:39 PM

Greetings all,

I have an issue where I am having trouble converting an ISO8601 timestamp into a readable value. These timestamp values are located and grabbed from an external XML file and I need a simple way to convert it into a readable value before posting on an HTML page.

Here is the code I'm initially pulling the data with:

Code:

<span id="Created0"></span>
<span id="Created1"></span>
<span id="Created2"></span>
etc...

<script>
if (window.XMLHttpRequest)
  {// code for IE7+, Firefox, Chrome, Opera, Safari
  xmlhttp=new XMLHttpRequest();
  }
else
  {// code for IE6, IE5
  xmlhttp=new ActiveXObject("Microsoft.XMLHTTP");
  }
xmlhttp.open("GET","externallink=xml",false);
xmlhttp.send();
xmlDoc=xmlhttp.responseXML;

var i=0,d;
while (d=document.getElementById("Created"+i)) d.innerHTML=xmlDoc.getElementsByTagName("Created")[i++].childNodes[0].nodeValue;
</script>

And an example of the external code from the XML file:

Code:

<PostItems>
      <member>
        <Author>user:chayavic</Author>
        <Body>@joelboss just saved someone's Christmas. What have you done today? There's still time. #c2alerts</Body>
        <Topics>
          <member>hashtag:c2alerts</member>
          <member>user:joelboss</member>
        </Topics>
        <Created>2012-12-12T23:41:50.948Z</Created>
        <Votes>
          <DownVotes>0</DownVotes>
          <UpVotes>2</UpVotes>
          <UpVoters>
            <member>
              <Timestamp>2012-12-12T23:49:22.789Z</Timestamp>
              <Voter>user:snyderm</Voter>
            </member>
            <member>
              <Timestamp>2012-12-13T00:17:28.380Z</Timestamp>
              <Voter>user:amyschra</Voter>
            </member>
          </UpVoters>
        </Votes>
        <PostId>da3316a1-bdda-40c6-8429-5d694ca6ecd3</PostId>
      </member>

It appears to grab and display the "Created" items perfectly, but how would I render them out of the ISO8601 format into something readable, say "December 13th, 8:32pm" before actually defining it as a span? (Or even AFTER it defines them, then just modifies the value?)

Been banging my head against a wall trying to figure this one out

Any help is appreciated!

**ReFreezed** · 12-15-2012 10:27 AM

Take a look at the Date object.

Code:

var dateString = '2012-12-12T23:41:50.948Z';
var date = new Date(dateString);
alert(dateString+'\n\n'+date.toLocaleString());

Thread: Convert External XML Timestamp to Readable HTML Display with JScript

Thread Tools

Display

Convert External XML Timestamp to Readable HTML Display with JScript

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions