>so force the date like the server is requesting (I can say that your server is
>not configured with default options).
>sql = "insert into thetable(datecolumn) values('" & format(date, "dd/mm/yyyy")
>& "')"

do u mean first u shud retrieve whats the date format on the server.
so if its dmy write the sql for dmy
and its something else
write the sql and insert as 'yyyy/mm/dd' format

1. so there would be 2 sqls for every date operation if i want my appl independent of server date format. Right ?????

2. and if regional setting is dd-mmm-yy format would fail, is'nt it ?