Skip to Content
author's profile photo Former Member
Former Member

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 !

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Oct 06, 2008 at 12:59 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Oct 06, 2008 at 01:01 PM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Oct 10, 2008 at 07:03 AM

    Hi Ramachandra,

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

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

    Date Conversion problem!

    Thanks

    SaNv...

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.