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

Converting TimeZones and XML Date Formats


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


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


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.