Select * from tbl where date=now()

Results 1 to 2 of 2

Thread: Select * from tbl where date=now()

  1. #1
    Dam Dates Guest

    Default Select * from tbl where date=now()

    1the column in the database is Date type with the format 09/03/1999<BR>2Select statement is where date = 09/03/1999, <BR>3. it doesn&#039t get any records?<BR>I tried changing it to text format but nothing.<BR>any GOOD explantions?<BR>

  2. #2
    Join Date
    Dec 1969
    Posts
    463

    Default RE: Select * from tbl where date=now()

    Notice the #&#039s in the following code.<BR>First set a variable = to the date function.<BR><BR>strSQL = "SELECT * FROM messages _<BR>WHERE date = #" & varDate & "# " <BR><BR>

Posting Permissions

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