I want to use interpolated
data from a SQL table in AF. I have a some time series data in a SQL
table. I link this table into AF. Now I want to see interpolated data between
points know in the SQL table. E.g.
point1: 200 1-Nov--2011
point2: 300 1-Dec--2011
To get interpolated data
from a formulate retrieving data from 4 attributes:,
a) value previous of the query (StartDate)
b) value next of the query (StartDate)
c) time of previous value (StartDate)
d) time of next value query date (StartDate)
So far so good, but to calculate the interpolated value at the query date I need to retrieve the Query date into a formula. That is were I got stopped. Does anyone know how to get the %StartDate% as a value in Formula data reference? Or does any know how to get interpolated data from a SQL table by configuration only, e.g. not making our own data reference?
Thanks for your help.