Operator "gt" incompatible with operand types "Edm.DateTime" and "Edm.DateTimeOffset"

[Former Member]

Hello Experts,

I am using SuccessFactors adapter in SAP CPI to fetch data from an entity in SF. I have following query in the channel,

Operation: Query(GET) ResourcePath :<Entity Name>?$select=<List of fields to be selected>&$filter=(startDate gt datetimeoffset'1900-01-01T00:00:00Z' and endDate le datetimeoffset'9999-12-31T23:59:59Z') Path to edmx : edmx/performancemanager10_successfactors_com_odata_metadata.xml

When I run this iFlow, I get following error,

Operator "gt" incompatible with operand types "Edm.DateTime" and "Edm.DateTimeOffset"

I checked this blog also - https://archive.sap.com/discussions/thread/3767947
but still I am getting the same error.

Any idea how can I resolved this issue?

Thanks in advance,

Netrey

[Former Member · Accepted solution]

Hi Guys,

Thanks a lot for your responses and help. I found the solution to this issue and thought to share it here so that other SCN users can benefit.

To filter based on dates, SAP provides two variables - "fromDate" and "toDate". Use the syntax as follows after you filter criteria

&fromDate=<from date in YYYY-MM-DD format>&toDate=<to date in YYYY-MM-DD format>

See example below,

$filter=company eq '9000' and status eq 'active'&fromDate=2018-06-07&toDate=9999-12-31

Thanks and Regards,

Netrey