Most data models involve an element of date or time. I can’t remember the last time I worked on a data model that didn’t involve date values anywhere in the data.
Business data invariably involves tables of transactions that include a point-in-time value . Sometimes a row of data might carry multiple DateTime fields to represent different actions relevant to that transaction. In the case of a customer order, there may be values to show the point in time of the original order, the pick-up date, the delivery date, and the invoice date. Downstream reporting requirements may need to group data ...
