Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Date Conversion problem!

Hi,

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 :

SENDER -


> XI------> RECEIVER

2008-05-23 -


>XI-------> May2008

2007-04-19 -


>XI-------> April2007

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.

Please Advice.

Regards,

Senthilprakash.

Edited by: senthilprakash selvaraj on Oct 10, 2008 8:19 AM

Edited by: senthilprakash selvaraj on Oct 10, 2008 8:20 AM

replied

Hi,

You can do it with the DateTrans standard function.

Specify the following in the pattern.

input pattern: yyyy-MM-dd

Target Date Pattern : MMMMyyyy

Thanks

SaNv...

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question