Using date-time effectiveness

Date-time effectiveness is used to state that records are valid for a specific period of time. This can be to enforce that every change to a record is time-stamped, allowing us to see the state of the record at any point in time. It can also be used to plan future states, such as a planned pay rise.

In our case, we will create an odometer table so that the user can enter the odometer setting for the vehicle and allow them to see the current and historical states of the record.

Getting ready

The example in this recipe builds on the vehicle table and form, but we can use this pattern to create a table and form that implements date-time effectiveness in any SCM project.

...