How To Convert Incomming Date Format to Our Own Format

[Former Member]

Hi All,

My Sceario is File XI-File

My Incoming File is Having the Date With Some DD.MM.YYYY

But I Want to Convert that Date Format to YYYY MM DD

So What i have to Do For this

Regards

Vamsi

[former_member192892]

If u wanna write an UDF go about it this way

function(String inputDate, Container)

{

Date date = (Date)DateFormat.parse(inputDate)

java.text.SimpleDateFormat format = new java.text.SimpleDateFormat("yyyy MM dd")

String outputDate = format.format(date);

return outputDate

}

[Former Member]

Hi u can create USD define function

sample code

String DB;

DB=DOB.substring(8,10)"/"DOB.substring(5,7)"/"DOB.substring(1,4);

return DB;

or else u can use DateTrans from ur standard function.

right click -> properties -> give the date format

regards

yugapreetha

Message was edited by:

Yugapreetha T

[Former Member]

Hi,

As Monika replies you can even use a date function category.

DateTrans : Converts date format I to another date format O.

<b>Cheers,

*RAJ*</b>

[justin_santhanam]

Krishna,

Use DateTransformation function in standard functions-Date.

Best regards,

raj.

[Former Member]

Hi

Use Date Function in Message Mapping.There are a variety of options available to which you can change your incoming date.

Thanks

[Former Member]

Hi,

GO FOR VALUE MAPPING

<b>

Cheers,

*RAJ*</b>