Ignition version: 7.9.4
DB: Sql Server
I have a simple custom method in a root container script window.
Changing the date on a calendar component calls this custom method, which in turn queries a db. The db column is titled “Date” and is of datatype “datetime”.
I get the following error when I call this custom method:
which says that “index 1 is out of range”. The calendar object has a datatype “Date”, while the db uses “datetime”. I think it might be a datatype mismatch, but I’m not sure. Does anyone know how to correctly bind this calendar date to my sql query?