Yeah, it’s strange that your call isn’t working from FSQL. I can’t see anything immediately wrong with it… However, before I actually try creating the procedure and calling it from FactorySQL, I want to suggest the first thing that came to mind when I read the problem:
Use the FactorySQL “ToDate” expression function to parse a string that you’ve built from the parameters (In the form of “year-month-day hour:minute:second”).
That is, create an action item whose mode is “expression” and whose text is:
[quote]ToDate(Concat({startTime_0},"-",{startTime_1},"-",{startTime_2}," “,{startTime_3},”:",{startTime_4},":",{startTime_5}))
[/quote]
The main benefit of this, if it works, is that it doesn’t need to round-trip to the database for the value, and thus will be much faster.
Let me know if this works or not!