Skip to Content
Jun 16, 2021 at 07:29 AM

Datetimeoffset and datetime problem of filter in Integration Center


Hi experts,

I tested like as below, OData API with FODepartment history data.

this test for filters Integration center especially date filter.

1. result : 3 data - it is working properly with modified date and effective date.
This result extracts data after the modification date in the from and to date periods of the effective date.$filter=lastModifiedDateTime+ge+'2021-06-14T00:00:00Z'+and+externalCode+eq+'209928'&&$format=json&fromDate=1900-01-01&toDate=9999-12-31&$select=externalCode,startDate,name_ko_KR,name_localized,lastModifiedDateTime

2. result : 4 data it is not working because of datetimeoffset in query. datetime also same result.
It is the same query, but if datetime and datetimeoffset are entered, all historical data of effective date from and to are displayed.$filter=lastModifiedDateTime+ge+datetimeoffset '2021-06-14T00:00:00Z'+and+externalCode+eq+'209928'&&$format=json&fromDate=1900-01-01&toDate=9999-12-31&$select=externalCode,startDate,name_ko_KR,name_localized,lastModifiedDateTime

the datetimeoffset and datetime are used in integration center. you can check preview.
If we set the modified date to a later day than today in the advanced filters and also set the effective date in the time_based filters, the modified date filter is not applied to the result because of datetimeoffset and datetime. I check preview.

I guess, if we remove the datetimeoffset and datetime words from the date of the modified date filter, we can extract the job info or department history data with both filters..

Therefore, I want the integration center to remove the dateitmeoffset and datetime that take the date value. if we have to use these, I want to check what value these function(datetimeoffset, datetime) returns so why the result is messed up.

Best Regards