Hi - I'm wondering how the delayed triggers functionality works. Are delayed triggers scheduled based on the date value at the time they're scheduled? Or is there a polling mechanism, so that if the date value changes the trigger will execute based on the new value?
I'm particularly curious about what happens if I change the value in a date field, when I have a delayed trigger set up based on that field. Is an additional delayed trigger invocation scheduled, so that I now have two invocations that will run on that record? Is it only newly-scheduled if I have the trigger flagged for Before/After Update? What happens if I change the date value to today - does the trigger run immediately?