2642826 - How is the filter Relative Date calculated in Integration Center?

SAP Knowledge Base Article - Public

2642826 - How is the filter Relative Date calculated in Integration Center?

Symptom

How is the filter Relative Date calculated in Integration Center?

Environment

SuccessFactors

Reproducing the Issue

  1. Go to Integration Center
  2. Click on My Integrations > Select your Integration
  3. Select the Relative Date Filter on Filter and Sort tab
  4. For example: select Last Run Time  - 2 months

  Last Run Time.PNG

Resolution

When we use the filter as Last Run Time - 2 months, here 2 months are calculated considering the number of days in both the months prior to the month of the Last Run Time date.

For example:
Suppose the Last Run Time Date is 30th April, 2018 , and then the 2 months are the months of March,2018 (31 days) and February,2018(28 days)
So the filter Last Run Time - 2 months = 30th April, 2018 - 59 days = 2nd March, 2018

One more example for better understanding, if the Last Run Time date is 15th May, 2018, then the 2 months would be the months of April,2018 (30 days) and March, 2018 (31 days)So Last Run Time - 2 months = 15th May, 2018 - 61 days = 15th March, 2018

Please note while calculating the above dates, the timezones are considered in GMT.

 

Keywords

Monthly, Relative Date Filter, Integration Center, Last Run Time , KBA , LOD-SF-INT-INC , Integration Center , LOD-SF-INT , SF Integrations - EC Payroll, Boomi/ HCI, API , How To

Product

SAP SuccessFactors HCM Core 1802