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

Date transformation

Hi All,

I am getting awiered error in date transformation function.

My source date is in the format(MM/dd/yy) and I need the target date in the format (yyyy-MM-dd). I have used the date transformation function available in the graphical mapping.

suppose I give the date as 09/29/06 I expected the target date as 2006-09-29 but my target date I get as output is <b>0006-09-29</b>. Can any one let me know why this happens and how to correct it?

Thanks & Regards,

Jai Shankar.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

5 Answers

  • Posted on Sep 29, 2006 at 09:34 AM

    hi,

    try target: dd-MM-yyyy

    if you still see the year like 0006 I suggest creating an OSS note as it looks as a bug

    Regards,

    michal

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 29, 2006 at 10:04 AM

    hi,

    in our system it works.

    source: MM/dd/yy

    target: yyyy-MM-dd

    Please make a doble check.

    Regards,

    wojtek

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Sep 29, 2006 at 10:07 AM

    Hi,

    Wo could get the correct transformation of Date format as you specified.

    I have tried the data type for date field as Date , Is this a problem? Can you check again?

    Regards

    Suresh

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 29, 2006 at 10:41 AM

    Hi Jai,

    did you set the parameters (doubleclick on it!) in the "dateTrans" correct?

    Format source: MM/dd/yy

    Format target: yyyy-MM-dd

    This works

    Regards Mario

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Sep 29, 2006 at 10:58 AM

    Hi,

    Here the reason must be SP version you are working on. I could get the correct results as my XI runs on SP16. You can go for UDF if you are familier with Java.

    Regards

    Suresh

    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.