Skip to main content

ODBC Import - Date Filter

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