date format changed with SQL

[skagr]

I am new in VB. My database(in Ms-Access) is containg a field "CURRENTDATE", I written a following routine to update CURRENTDATE :-
DIM CN AS NEW ADODB.CONNECTION
DIM CnStr AS STRING
CNSTR="PROVIDER................."
CN.OPEN CNSTR
RS.EXECUTE "UPDATE <TABLE NAME> SET CURRENTDATE = #" & NextDate & "#"
offcourse SQL updates records but in mm/dd/yyyy format while NextDate variable is well in dd/mm/yyyy format. My regional setting is dd/mm/yyyy.

VB Experts please tell me why is it so ?