Connector date related issues

[Former Member]

Hi

I am having trouble getting data using rfc HRWPC_RFC_GET_OBJECTS with the .net connector. I am able to get data out of the system using certain dates, e.g. "27.01.2005" but using the current date as begin and end date returns the error "NO ROOTS FOUND". The function returns valid data when called with the current date from SAP and using JCo.

This is the line of code:

proxy1.Hrwpc_Rfc_Get_Objects("15.02.2005", 0, "15.02.2005","EN","", "ALBERTA", "A_ALL",out cachedate,out cachetime,out showastree,ref resultobject,ref resultstruct);

Can anyone help?

[reiner_hille-doering · Accepted solution]

Here's a quote from Guangwei's answer in OSS:

The .NET Connector maps ABAP date and time types to .NET string using the ABAP standard formats of YYYYMMDD and HHMMSS respectively. So your input should be "20050215" in stead of "15.02.2005". You can also use RfcConvert.DateTimeToRfcdate() to convert a .NET DateTime value to a string in ABAP format.