Hi I am using Ignition 8.1.4 and I have a table pulling data from the database, I am trying to filter the query by date range, so I put a Date Range component and have my query like this:
SELECT BATCH FROM BATCHES WHERE ACTUALSTARTDATE >= ‘{Root Container.Power Table.startDate}’, but the date format of the component is giving back the following: ‘2021-03-25 23:59:59.999’
Is it possible to remove the .999 milliseconds? That is causing my query to fail.
Thanks for the feedback