Value On Date [ValueOn]

Return to Complete List of Functions

The Value On Date function determines the value of a field on a given date. Parameters ------------------ Data            The data to analyze. This is typically a field in a data series or a calculated value. Year            The year of the date. Month         The month of the date. Day             The day of the date. Function Value ------------------------ This function determines the value of a field on a given date. The value before the given date is zero. If the data series starts after the given date, the value will remain zero. If the data series starts before the given date, but does not contain a record on the given date, the value on the first record before the given date is returned. This is essentially the "last known value" on the given date.