GetValueByDate

Syntax

GetValueByDate(Input: Variant, Date: Variant)

Parameters

Input. The series, which value should be obtained.

Date. The date, for which the value should be obtained.

Description

It returns series value to the specified date.

Comments

As the value of the Value parameter constant, parameter or object of the TimeSeries type can be sent and as the value of the Date parameter - number, string or parameter.

Example

Formula Result Application
= GetValueByDate({GDP|Anchorage[t]}, 2005)*2

Value of the GDP|Anchorage series for 2005 will be multiplied by two.

It can be used in formulas of calculated series of time series database and in formulas of attribute-based models of modeling container.
= GetValueByDate(X1, "2015A")*2

Value of the X1 factor for 2015 will be multiplied by two.

It can be used in model variable-based formulas of modeling container.

See also:

Functions Available in Expression Editor  Other Functions IModelling.GetValueByDate