SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    Procrastinator Extraordinaire lucas's Avatar
    Join Date
    Oct 2000
    Location
    Springfield, Missouri, U.S.A.
    Posts
    320
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    trying to query date, returns no records in access

    i'm using the following sql statement to query an access db in asp:

    Select Top 200 * From [Copy of Tank - Calculation Number List] where [Date]= 3/23/2000

    the date field is set to date/time and that record exists, however it will not return that record.

    anyone know what i'm doing wrong here?

  2. #2
    Procrastinator Extraordinaire lucas's Avatar
    Join Date
    Oct 2000
    Location
    Springfield, Missouri, U.S.A.
    Posts
    320
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    to answer my own question, it needs to be changed to:

    Select Top 200 * From [Copy of Tank - Calculation Number List] where [Date]= #3/23/2000#

    where there are two "#"'s around the date.


Bookmarks

Posting Permissions

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