Date Range Problem
Issue: I'm trying to query a SQL table for a range of dates. I've created the query and can run it just fine. The format in the table is YYYY-MM-DD HH:MM:SS.
I've tried to use date picker to get the dates but it comes out as M/D/YYYY HH:MM:SS
I tried converting it with the "Convert to string" component but that just seems to ignore it and sends it out the same way it came in..
So then I just tried using drops down list components to create the date but then the SQL component squaks about it not being a DATE.
This seems like it should be easy..
Changing the SQL table isn't a possibliity since its already populated with over a thousand records..