AnsweredAssumed Answered

Date Filtering in Successfactors

Question asked by david.konatschnig on May 13, 2016
Latest reply on May 13, 2016 by 40592737


Hi

I am currently having a business use case where i need to filter some OData Entity from Successfactors by it's Last Modification Date.

So lets say, i want to have all entries that have been modified within the last 30minutes.

On the Entity, there are 3 Fields that are used for LastModificationDate.

-LastModificationDate

-mdfSystemLastModificationDate

-mdfSystemLastModifiactionDateWithTZ

 

In my connector, i set a filter with the Date in Format yyyy-MM-dd'T'HH:mm:ss.SSS'Z'

 

The first thing that confuses me:

I can only apply the filter on the field mdfSystemLastModificationDate, when i set the filter on one of the other fields,

the connector times out...it never stops.

 

second, i think the filter only applies on the hours of the date, but not on the minutes.

if i set the filter by relative datetime -30minutes, i still get entries that have been modified 45 minutes ago, 50 minutes ago, etc...

 

So my question now is, can i change that somehow?

The Reponse Profile uses this format for the LastModified Fields: yyyy-MM-dd'T'HH:mm:ss.SSSZZ

I've been playing around a bit with the date format but it doensn't change something.

Outcomes