Skip to Content
0

Query regarding addition of Date and No of months

Sep 20, 2017 at 12:04 PM

24

avatar image
Former Member

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.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Gabor Molnar
Oct 24, 2017 at 12:38 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded