date compare

Results 1 to 3 of 3

Thread: date compare

  1. #1
    Ricardo Rocha Guest

    Default date compare

    &nbsp;<BR> Well, i want to retrieve from a database the records that correspond to a date after the current date... i have a field "data" in the table and i&#039m using this:<BR><BR>sqlstring="Select * FROM resultados WHERE data &#062; " & date() & " ORDER BY data"<BR><BR> This was working fine until the end of September. First day in October and it just retrieves all records. I was using it for a few days only, so i don&#039t really know what the problem is!<BR><BR> Hope for help!<BR>

  2. #2
    Join Date
    Dec 1969
    Posts
    116

    Default RE: date compare

    try surounding the date with #<BR><BR>eg<BR>data &#062;=#"&datevar&"#<BR>you may need to put the date into a var first<BR>hope this helps<BR>

  3. #3
    Ricardo Rocha Guest

    Default RE: date compare

    i forgot to put it in here, but i&#039m using it in the page<BR><BR>the problem persists

Posting Permissions

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