Subject Re: [ib-support] Date type & strings representing dates
Just been stung by the same problem.

It depends where you are using the date. In 'raw' SQL
statements it has to be in american format mm/dd/yyyy, which
is why can be more useful. Other levels of
working do the conversion for you. It's a bit of a mess

Lester Caine
L.S.Caine Electronic Services