Skip to Content
avatar image
Former Member

Query regarding addition of Date and No of months

In SAP MDM, I am trying to add a date field and a text field containing "No. of months" with an assignment expression.

For e.g. Update Date=09/15/2017 and No. Of Months=9, so while i use Update Date+No. Of months, the result is 09/24/2017 i.e. the data is getting added to the date i.e.15th of the Update Date field which is not expected.

Could you please suggest any way out for this addition so that the update is correctly made and increment the month data of "Update date" field.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Oct 24, 2017 at 12:38 PM

    Hi Divya,

    you can use the "Left" function to get the specified number of character from the start of the string.

    Or if you want to read out a specified section of a string, then use "Mid".

    For further info have a look at the Data Manager Reference Guide: https://help.sap.com/http.svc/rc/bcfe3781d8ed4704b18ad2bac24c5cc8/7.1.18/en-US/MDMDataManager71SP18.pdf -> EXPRESSION FUNCTIONS ...

    Best regards,

    Gábor

    Add comment
    10|10000 characters needed characters exceeded