I am using Delphi 2009 with postgresql DB.I have got an error 'is not a valid date and time' when I try to filter a string like 'aaaa-bbbb-cccc'And the field is in varchar type in DB but not date type.

could you please provide a small snippet of code how you try to do the filtering? It would be good if you also could provide a small table declaration and some sample data. This enables us to generate a small test case.With best regards,