Date filtering in data grid

Hi all,

when I create a filter on a date field in the data grid and use the [...] button to select a date from the table data, the filter is always created in the American date format. Is there a possibility to create such a filter in the format that is defined in the TOAD options?

Best regards,

Hi Rainer,

There are several places where a filter can be set. Can you post a screen shot please?



Hi John,

as you can see in screenshot1, I have set the date format in the TOAD options to like it is usual in Germany. Now I select a data row, and wht I get then ist the filter in the American format, as on screenshots 2 and 3.

And what I would like to have (if somehow possible) is a filter like

ABRECHNUNG = TO_DATE('30.04.2009 00:00:00', ' hh24:mi:ss')

Best regards,


Oh, I see what you mean. You want the to_date expression to be in the same format as your grid settings.

We have some code in "Export Dataset" that creates the insert statements that way. I'll see if I can generalize that code and use it here too.


That sounds very good :+1:t2: :+1:t2: :+1:t2: