mapping UDF

[Former Member]

I need a udf Which will convert the date format yyyMMddhhmmss to YYMMDD

best regards

Manas Mahani

[Former Member]

Hi Manasa,

You can execute this without UDF. Use " Transform" function in the Date functions.

When you are using the UDF....you keep the strucure as "yyyMMddhhmmss" for that clickon Trnasform function and there you can see <b>ShowAdvancedProperties</b>...there u can find the format of the source which you are expecting and also change the strucutre of you target expected format.

You please try this and check the mapping it will get execute.

Pleaes let me know if you have any queries..!

Thanks and Regards,

Chandu.

[Former Member]

Use Standard Date Function DATATRANS. It have the property for format and input is the source date field. It will convert the date format to required specified format which you menstion in the DARTATRANS function.

Warm Regards,

Vijay

[justin_santhanam]

Manas,

Use <b>DateTrans</b> which is available in Standard Date function category.

-Raj

[Former Member]

Why to use UDF.

U can use standard substing function of Text category providing position of YY/MM/DD in source string & then u can concatenate them to make required string.

Regards

Sushil