Graphical mapping problem.

[Former Member]

Hi,

I have problem in date format could you please look at below problem.

Eg: my source date looks this 2008/05/31 i.e yyyy/MM/dd and I want my target to be May31 I tried using different options iam not able to see the correct option. Is that I have to write an UDF?

Thanks

sunil

[vijay_kumar133]

Hi sunil,

When ever you come accross problem in data transformation .. just type in Source data filed as you required and type manually required format in target format...

Most important keep in mind is y-year d-date M-month

here y and d are small and onley M is caps..then it will solve your problem

Reward points if usefull

Regards

Vijay Kumar

[Former Member]

Hi Sunil,

In the standard function chose DATE->DATE TRANS.

Open that date trans and double click on the date, in the target format put u2018MMMddu2019 that will solve your problem. MMM(Capital Letters) will give May and followed with date.

Thanks

Vikranth

Edited by: Khimavath Vikranth on May 31, 2008 12:08 PM

[Former Member]

Hi,

Yes here you can write the UDF.

Take the input as date and write code

switch(month);

case month = 1 then Jan;

break;

case month = 2 then feb;

break;

..

like you can write the code, finally you concotenate the day with this month code and return that variable.

like String s = concat(DD + monthcode);

Im just gining the hint according to that you can write the code.