Asp datetime problem with non-Unicode languages

[neon20]

hi everybody,

i have datetime problem with my access database

im not able to update the datetime field in the msaccess table using

objcon.execute "update users set us_userlastlogin='" & now() & "' where us_userid= '" & us_userid & "'"


i have non-Unicode language as Arabic in Regional and Language Option in the control panel. When i change this to US english eerything works fine.

But if it is arabic, the query is works as

update users set us_userlastlogin='03/03/2007 05:44:21 م' where us_userid= 'anas'

instead of

update users set us_userlastlogin='03/03/2007 05:44:21 PM' where us_userid= 'anas'

ie the datetime field doesnt accept م character

is there any convert or alternative methods for this?

thank you
neon