Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > microsoft.public.scripting.vbscript > #11403

Re: XML convert pubDate, dc:date or alike results into a VBS Date format ?

Show all headers | View raw

Hello Rudi,

Am 31.10.2016 um 11:06 schrieb R.Wieser:
> I'm using XMLDOM to extract some data from an RSS feed, and would now like
> to convert the returned 'pubDate", "dc:date" and others like it dates into a
> VBS date format.  Examples:
>
> Mon, 31 Oct 2016 00:00:00 -0600
> 2016-10-28T07:00:00+00:00
>
> The build-in "CDate" method can't handle the above.
>
> I could just throw some homebrewn parsing-fu at it, but if there is alrady a
> build-in method I would rather use that. :-)
>
> tl;dr:
> Does anybody know if there is a build-in method to convert the above two
> examples into a VBS date format ?
>

i think this is an ISO 8601 date format. I have found an ISO8601 class 
for vbscript with google. Perhaps you'll find it useful:

http://website.lineone.net/~saphena/iso8601.vbs 
<http://website.lineone.net/%7Esaphena/iso8601.vbs>

  Ulrich

Back to microsoft.public.scripting.vbscript | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

XML convert pubDate, dc:date or alike results into a VBS Date format ? "R.Wieser" <address@not.available> - 2016-10-31 11:06 +0100
  Re: XML convert pubDate, dc:date or alike results into a VBS Date format ? Ulrich Möller <knobbi38@arcor.de> - 2016-10-31 12:42 +0100
    Re: XML convert pubDate, dc:date or alike results into a VBS Dateformat ? "R.Wieser" <address@not.available> - 2016-10-31 13:28 +0100

csiph-web