This example demonstrates using the Previous() function and WHILE clause to “fill in” values in a date range.

In this exercise, a transaction file provides Products, Prices, and the date the Price is effective.

The goal is to determine the Product Price for any given date.