Error when creating a filter in the schema browser: "ORA-01843": not a valid month (4270877)

When creating a filter for a column that has a date datatype an ORA-01843: not a valid month error is generated.

The data displayed in data grids is not necessarily exactly how it is stored in the database.
Its a representation of the date based on the date settings set up in View | Toad Options... | Data Grids | Data | Date Format .

To determine how the date is stored in the database, run a select query onthe date column in SQL*Plus.

RESOLUTION 1:

Ensure the date typed into the filter criteria matches the format stored in the database.

RESOLUTION 2:

ChangeView | Options | Data Grids | Data | Date Format to match what is displayed in SQL*PLUS.

Note: This will change date formats for all data grids.