I have a SQL Table with a column of “Date” type. When I query it in SQL all that is returned is a date which is what I need. When I do the same query in Ignition its adding a time to the date rather than just returning the date. I tried using the SQL convert to date but that didn’t work either.
Basically I need to populate a date picker date based on an sql entry but its not working since its coming in as a date time format.