How is the filter Relative Date calculated in Integration Center?
Reproducing the Issue
- Go to Integration Center
- Click on My Integrations > Select your Integration
- Select the Relative Date Filter on Filter and Sort tab
- For example: select Last Run Time - 2 months
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.
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.
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