Skip to Content
0
Jan 09, 2012 at 10:18 AM

Concatenation of two fields using formula in Transformation

1470 Views

Hello SDN'ers,

I have a scenario where, I need to concatenate the valid from date and valid to date information and place it in a different infoobject called Date_RNGE.

I am using the below Formula to concatenate these two fields

FROM_DATE & '-' & TO_DATE

It works fine but, the output is not in the format in which I want.

Example:

With the above formula, I am getting the output as shown below,

Current Output view,

Valid From : 12/11/2010

Valid To : 01/10/2011

After Concatenation:

Date Ranges : 20101211-20110110

Expected Output is,

Valid From : 12/11/2010

Valid To : 01/10/2011

After Concatenation:

Date Ranges : 12/11/2010-01/10/2011

Any advice is appreciated.

Regards,

Vinoth