In my company work, we often use two _Date_ or _DateTime_ fields to express a range when the row data is valid.
Rediscovering PostgreSQL and highlighting some features.