RE: [BizTalker] Controlling XSD datetime output from Maps

[Nikolai Blackie]

I already have a function that performs this, basically it converts a julian date to datetime, then to string using ToString("ddMMM yyyy HH:mm:ss") but it still converts it to the full UTC format by the time it exits the mapper.
 
Peter Cuttriss on the NZ BizTalk list has mentioned that maps inside an orchestration will convert to UTC, but if applied on a send port map this is not the case. The map I am using actually utilises two input messages, which is not possible when applying a map on the send port (or can you?).
 
I guess an alternative could be to reformat the date in an expression block after the mapping has occurred.
 
 
 Nikolai Blackie
 Development & Integration Services
 
 
 
 

________________________________

From: biztalkerlist@xxxxxxxxxxxxxxxxxxxxxx on behalf of Sachin Kulkarni
Sent: Thu 2/06/2005 12:32 p.m.
To: BizTalker@xxxxxxxxxxxxxxxxxxxxxx; biztalk@xxxxxxxxxx
Subject: RE: [BizTalker] Controlling XSD datetime output from Maps



What I normally do is enforce the format using additional functoid. Not
an ideal solution. but does the job. So even though input and output
field types are the same (datetime) I use script functoid with inline C#
like this

public string GetShortDateTime(string strLongDateTime)
{
              return Convert.ToDateTime(strLongDateTime).ToString("dd
MMM yyyy HH:mm:ss");
}





-----Original Message-----
From: biztalkerlist@xxxxxxxxxxxxxxxxxxxxxx
[mailto:biztalkerlist@xxxxxxxxxxxxxxxxxxxxxx] On Behalf Of Nikolai
Blackie
Sent: Thursday, 2 June 2005 10:08 AM
To: biztalk@xxxxxxxxxx; BizTalker@xxxxxxxxxxxxxxxxxxxxxx
Subject: [BizTalker] Controlling XSD datetime output from Maps

Does anyone know of a way to enforce how BizTalk outputs datetimes. I
have a map and custom functoid that outputs a date in the form
'2005-06-02T09:41:24' to a destination field of xsd:Datetime, but by the
time the message makes it out of my map the date is in the format
'2005-06-02T09:41:24.0000000+12:00' which is completely W3C valid. But
an external system I am integrating with says that it is invalid and
rejects it. I need to remove the milliseconds and GMT zone.

I don't want to resort to altering the destination schema to use string
data types either.



 Nikolai Blackie
 Development & Integration Services






to unsubscribe to this list, please send a message back to the list with
'unsubscribe' as the subject. Powered by mailenable.com - List managed
by http://www.readify.net






--
Confidential: This email is intended only for the person or entity to
which it is addressed. The information contained in this email may be
confidential and privileged. Any retransmission, review, dissemination or
other use of, or taking of any action in reliance upon, this information
by persons or entities other than the intended recipient is prohibited.
If you received this email in error, please let us know by reply and
destroy all copies of it. Thank you.



to unsubscribe to this list, please send a message back to the list with 'unsubscribe' as the subject. Powered by mailenable.com - List managed by http://www.readify.net







to unsubscribe to this list, please send a message back to the list with 'unsubscribe' as the subject. Powered by mailenable.com - List managed by http://www.readify.net

<<winmail.dat>>