Hi there,
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!
Mike
mkeiffer33
Offline
Last seen: 1 month 13 hours ago
Joined: 12/23/2015 - 17:54