Ok, I solved the syntax problem stated above by simply adding “SELECT” in front of it (d’oh), but I am still running into that datetime field overflow problem.
The action item seems to run successfully, since I see a date in the value column, but I am still running into the overflow when the group is triggered. I’m thinking that there must be some casting behind the scenes when the insert statement is assembled, since you have to choose the type when mapping your opc items to table columns. Any ideas about this?
I’m starting to think that I’m going to have to alter the table columns to datetimes to get things to work right… 
–HandledException