Exploring the use of OData for fetching data.
In my company work, we often use two _Date_ or _DateTime_ fields to express a range when the row data is valid.