SAP HCI-DS Add months to the input date value, "add_months" function not working.

[former_member1310066]

Hi All,

We have a requirement to add 1 month to the input date field. The input is

2010-04-01T00:00:00 and expected output is 2010-05-01T00:00:00.

Connection details: SAP SuccessFactors to HANA DataBase. I have used predefined "add_months" function and I am getting below error:

<JDBC Adapter> does not support function <add_months>. Check your dataflow.

I am attaching images of my approch.

Please suggest any other ways i can get the expected output or anything we need to fix regarding JDBC Adapter.

Regards,

Sravan

error.pngfunction-use.png

[former_member423067]

Hello Sravan,

Add_Months() function should work irrespective of the receiver system. are you passing the date in right dateformat ?

Not sure, why presence of this function is not being supported by the JDBC. These is not mentioned in documentation or any exception mentioned in help page for this function. Better raise a ticket with SAP.

Just to debug the issue. Try passing the date value to target with a simple hard code date as 02.13.2020 or sysdate() or even the input date without adding months. Lets check, how this works.

if this has become a show stopper, Last option might be to split the flow as 2 flows . SF to File ( use "add_month" here) and File to DB.

with regards,

Nazeer