I am trying to write a field function that uses data extracted from a table. This function needs to identify what the current time is and extract a value from a table corresponding to the present time. The table will have several columns 1 of which will be titled 'time'.
I have been looking at the help files and it seemed to be unclear of how this could be achieved.
Any help would be appreciated
I have since solved this problem from another source this is the code I have been using
'interpolateTable(@Table("Table-Name"), "time", LINEAR, "Column-Name", $Time)'
|All times are GMT -4. The time now is 18:06.|