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