Help needed with XML date & time formats

HCL Domino Domino Forum
1

A typical XML date / time as exported by Notes looks like this:

20040628T220618,33-05

  1. Most of the items in the date are obvious. What is the part after the comma? My guess is that it is hundredths of seconds and the time zone, but I am having trouble finding information to verify this.

  2. Is there a built in method in LotusScript to convert this string to a usable date/time (including the time zone) or do I have to parse this myself (or can I convert it with XSLT)?

Thanks in advance for any help.

2

Subject: Standard ISO8601 format…

See Date and Time Formats for details…

Thomas - IBM

3

Subject: RE: Standard ISO8601 format…

Thanks Thomas, that helps.

Is there a standard LS method for converting an exported XML date time to a variant or NotesDateTime object or is it up to me to parse and manipulate it?