Even collected it can be formatted thus.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Andy Wiggins" wrote in message
...
My code usually collects a date from somewhere, assigns it to a variable
and
then passes it on to something like the OP's query. I was interpretting
the
example in those terms and not assuming the OP was actually using a
hard-coded date :-)

--
Andy Wiggins FCCA
www.BygSoftware.com
Excel, Access and VBA Consultancy
-

"Bob Phillips" wrote in message
...
Have you tried an unambiguous date string like "15-Jan-2005"?

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Andy Wiggins" wrote in message
...
Try wrapping the date in the FORMAT function so, instead of
#15/01/2005#,
you have FORMAT(#15/01/2005#,"dd-mmm-yyyy").

It just might be that VBA or SQL (or both) are trying to recognise an
American date format rather than the English format.

--
Andy Wiggins FCCA
www.BygSoftware.com
Excel, Access and VBA Consultancy
-

"Santiago" wrote in message
...
Hey guys,

I'm trying to update some data in an Access DB from Excel using ADO
&
SQL.
I'd like to update some fields with a defined criteria using the
WHERE
clause
in SQL, but dates seem not to work...

I use the SQL string like:

UPDATE [table] SET [field1] = 'aa', [field2] = #15/01/2005# etc... _
WHERE [field3] = 'bla' AND [field4] = #01/01/2005#

I believe that the problem is the date I'm filtering... I copied the
whole
SQL string into access and did not work. But if I remove the date
criteria
seems to work.

I appreciate your help.
Thanks & Bregards

Santiago