I’m pretty new to Ignition, and I have seen other threads related to this topic, but have not found anything that resolves this issue.
I need to use the report viewer with a date range component to set the start and end dates for my sql query which is microsoft sequel. I have seen that I need to stick to using UTC time, but I do not have that option. I have passed the Start Date and End Date into Strings formatted to be accepted into SQL, but I get this message when I execute in the Database query browser:
“Conversion failed when converting date and/or time from character string.”
Is there a way to get this query to work with MSSQL without going to UTC time?