set value...timestamp – GREAT!

[Brian Williams]

If only life were equally adjustable...

...

set value of "Power5" to powerUsage timestamp ((current date) - 300)

...

Brilliant.

Thanks James

Note: I am reading a utility-related database, asking for power consumption (kWh) for the past 5 minutes. Before this feature addition, a graph of the results represented the actual usage shifted by 5 minutes (i.e. after the fact); now the reading is in the correct time slot, which is important when the graph also includes average load (kW) during the past 10 seconds (which I take at one minute intervals).