Effective dating allows you to store historical data, see changes in your data over time, and enter future data. For example, you may want to track several events in the career of John Smith: when he was hired, transferred, and promoted. By inserting rows of data based on his employee ID, and significant dates, you can build a job history.