Date Conversion problem!
I have a MS SQL Database.
They are sending Date to XI. and I need to convert the Date sent by the sender and Give to Receiver in the Below Format :
> XI------> RECEIVER
SENDER DATA TYPE: datetime
How to achieve the Receiver format above specified?
How to achieve the above type of conversion in XI.
How to convert the Date sent by sender and Give the month and Year to the receiver in Above format mentioned.
Edited by: senthilprakash selvaraj on Oct 10, 2008 8:19 AM
Edited by: senthilprakash selvaraj on Oct 10, 2008 8:20 AM
You can do it with the DateTrans standard function.
Specify the following in the pattern.
input pattern: yyyy-MM-dd
Target Date Pattern : MMMMyyyy