Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 4 of 4
  1. #1
    New to the CF scene
    Join Date
    Jan 2005
    Posts
    6
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Unhappy Syntax error in date

    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?

  • #2
    Supreme Master coder! glenngv's Avatar
    Join Date
    Jun 2002
    Location
    Philippines
    Posts
    11,042
    Thanks
    0
    Thanked 251 Times in 247 Posts
    Quote Originally Posted by G.A.
    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.

  • #3
    New to the CF scene
    Join Date
    Jan 2005
    Posts
    6
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Unhappy

    i know! but how can this be done

  • #4
    New to the CF scene
    Join Date
    Jan 2005
    Posts
    6
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Thumbs up

    i did what you said and finally it worked!! thanx a lot!!!


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •