I have a query related to filtering on date, What is the convention whether the data returned should include the end date or it is one day less than end date?
I mean if date range is from 5th Sep 2023 to 27th Sep 2023 so data should include both dates or exclude 27th Sep 2023.
Documentation does not specify on this?
Thank you in advance.
Filtering and attribute selection rules are described in the TMF630 (TMF REST Design Guidelines) document
Thank you for direction, Let me check,
Chapter 1 of the design guidelines includes a list of the comparison operators to be supported on the filter query string. Both variants should be supported, gt (greater than) and gte (greater than or equal), similarly lt and lte. So the issue now is how to translate end-user (human) input into the query string. In my view, date ranges should be interpreted expansively, i.e. from the beginning of the from date (T00:00:00.000) to the end of the to date (T59:59:59.999). These are local times, and will likely need to be translated to UTC before applying the query, assuming that persisted dates are stored in UTC.
Hope it helps.