SQL string with date doesn't work

[Andreas]

Hello,

I have a sql-string in my vba code but I think I made a mistake in the
syntax. I tried several things, but get always an error.

Further: the database is used in several countries, do I have to
convert the date (here in Germany it is stored like below)?

sql = "UPDATE tab_Cards_2008 SET num_complete = 1 " & _
"WHERE dat_DateColl = 01.01.1911 OR num_1=99"
DoCmd.RunSQL (sql)

Thank you very much for your help!

Andreas

 

[Glenn Siswick]

Hi Andreas,

Take a look at the following link for a full explanation:

http://allenbrowne.com/ser-36.html

Regards,
Glenn

 

[Andreas]

perfect, I love the usenet! Now it works,

Thank you very much!

Andreas