10-jan-2001 or I believe 10-jan-01 will be fine
10.01.2001
01/10/2001
Also I beleive there is a 20010110 format, but I've never used it.

I always go for 10-jan-2001 as there is no ambiguity.

Did your insert not work?

news:451F98000414D611810100805F1998774358EC@...
...

> Hi everybody,=20
> I have a problem, I'm working with excel to do some inserts
> stataments depending on what information I must upload to the IBASE. I

have

> Date Constants, like '10-JAN-01', how it must be in the SQL statament, is
> like:=20
>