Skip to Content
0
Former Member
Sep 02, 2010 at 03:31 AM

Converting TimeZones and XML Date Formats

229 Views

Hi guys

I am using xMii 12.1 SP 5

I have a requirement to build and send xml messages to PI

The Format I need to specify in my message is

<CreationDateTime>2010-09-02T03:00:56.000Z</CreationDateTime>

The format generate by defualt (using a date vairable) is

<CreationDateTime>2010-09-02T11:00:56</CreationDateTime>

So you can see I have 2 problems

#1 - How do I convert my datetime to UTC time ? (I am currently +8GMT but obviously dont want to manually adjust for daylight savings)

#2 - How do i specify the expected format.?

Any/All suggestions would be appreciated.

I want to do all of the above within a transaction if possible, but I can potentially do an XSLTransform on my created message if necessary.

Chris