>Disagreed. In Brasil I think a date is still a date but just in DMY 'format'. It is a universal data type that shouldn't be different in Brasil. Use a date as a date as I said (sorry I wouldn't reply here if you were kind enough to reply there). You should have used parameters from the start, that is no discovery but still it would need you send a date as a date and requires code change.

Excuse me, my bad english can be cause confuse.
I use Ctod and Dtoc functions to concatenete the date with SQL string, but in my TextBox I have a data of the type Date in DMY format