Date compare

Results 1 to 2 of 2

Thread: Date compare

  1. #1
    Ricardo Rocha Guest

    Default Date compare

    I&#039m using a SQLstring where i would like to select all the records on a table after a specific date... Something like:<BR><BR>sqlstring="Select * FROM tablename WHERE date &#062; " & CDate("22/09/99") & " ORDER BY date"<BR><BR>only this doesn&#039t work... it just selects all the records!

  2. #2
    Join Date
    Dec 1969
    Posts
    168

    Default RE: Date compare

    Give this a try...<BR><BR>sqlstring="Select * FROM tablename WHERE date &#062; #" & CDate("22/09/99") & "# ORDER BY date;"

Posting Permissions

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