Need an "On Change and/or Rate" Trigger for FactorySQL

Hi,

To store the last execution, you could just have a trigger action item that was at the bottom of the list which was:

StoreVariable("group1_lastrun",now())

To get it back and check the difference, you could do the following:

DateDiff(GetVariable("group1_lastrun",ToDate("2000-01-01")),now(),"sec")

That will return the number of seconds between the last run, and now, with a default way in the past if it’s the first time the group has run.

Hope this helps,