Does anyone know how data can be imported using the ODBC connection feature in IDEA with applying a filter on a date field? I have tried numerous formats for dates ('YYYY-MM-DD') and ('MM/DD/YYYY'), using both a live Oracle database and Excel practice files but nothing seems to work. I can filter on character and on numeric fields with no problems, but date fields do not seem to work.
Does anyone know how to fix this or is this a bug in IDEA with the ODBC connection?
Any help would be appreciated!
Last seen: 2 months 5 days ago
Joined: 12/23/2015 - 17:54