Skip to Content

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

DATE Conversion

HI All,

I would like to convert the date from 2008-10-07 to 07-OCT-2008.

I have tried to use DATE transform to convert the same.

I can convert the source Date (2008-10-07) to target as 07-10-2008.

But, My requirement is to display the Month in Chars rater than in Digits .

Please suggest me any good Mapping which can display Month in Characters.

Thanka !

Former Member
Former Member replied

Hi,

you could use 3 substring functions.

In your example you will have:

07-

10

-2008

The month value goes inside a FixValue function.

Then you concat your three substrings together.

If you do it like that you should check first if the length of input string is 10 chars.

Regards

Patrick

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