Google Spreadsheet ImportXML - can't figure out how to get time attribute

arifkhan

New Member
I'm having trouble using the \[code\]ImportXML()\[/code\] function in Google spreadsheets. I would like to retrieve the time of posting on several Reddit posts in a spreadsheet, but I'm only having luck getting 28 Apr 2012, instead of 2012-04-28T02:19:06.348481+00:00, which is what I would like. For example, on this web page, I look in the source and see the following:\[code\]<div class='spacer'><div class="linkinfo"> <div class="date"> <span>this post was submitted on </span> <time datetime="2012-04-28T02:19:06.348481+00:00">28 Apr 2012</time> </div><div class="score">\[/code\]However, this is the only line I can get to do anything:=ImportXML("http://www.reddit.com/r/BuyItForLife/comments/jtjuz/bi4l_mission_statement_rules_etc/","//div[@class='date']")Any suggestions? I've been searching and trying and searching and trying, and nothing is working.
 
Back
Top