DATE Conversion

[Former Member]

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 · Accepted solution]

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

[santhosh_kumarv]

Hi Ramachandra,

Check this thread for a optimistic solution for your issue...!

You can achieve this just by using the standard DateTrans function.

Thanks

SaNv...

[ParvathyS_SAP]

Use substring function and fixed value function

source is of YYYY-MM-DD format

target should be of DD-MON-YYYY format

so check the input is of substring length 10.

thats (0..9)

and substring (5,6) should be converted to month using Fixvalue and target will be of length 11.