...

View Full Version : Syntax error in date



G.A.
01-25-2005, 10:16 AM
i'm trying to make a counter, everything seems great except for a small error:
Error Type:
Microsoft JET Database Engine (0x80040E07)
Syntax error in date in query expression 'date > # 25/01/2005 11:12:19 ص #'.
/counter.asp, line 453


the error line is as follow:
line 452-----CounterSQL = "select count(date) from cb_counter where date > # " & formatdatetime(now(), VBGeneralDate) & " #"
line 453-----CounterRS.Open CounterSQL, CounterCon



what can be done?

glenngv
01-25-2005, 10:33 AM
i'm trying to make a counter, everything seems great except for a small error:
Error Type:
Microsoft JET Database Engine (0x80040E07)
Syntax error in date in query expression 'date > # 25/01/2005 11:12:19 ص #'.
/counter.asp, line 453


the error line is as follow:
line 452-----CounterSQL = "select count(date) from cb_counter where date > # " & formatdatetime(now(), VBGeneralDate) & " #"
line 453-----CounterRS.Open CounterSQL, CounterCon



what can be done?
The problem could be in the AM/PM indicator which is in arabic(?). Change the symbols set in sytem settings for time to AM/PM.

G.A.
01-25-2005, 11:19 AM
i know! but how can this be done :o

G.A.
01-25-2005, 12:33 PM
i did what you said and finally it worked!! thanx a lot!!! :D



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum