Results 1 to 1 of 1

Thread: Problem with Dates

  1. 06-24-2004, 01:56 PM #1
    SteveReinertson
    SteveReinertson is offline Registered User
    Join Date
    Jun 2004
    Posts
    2

    Problem with Dates

    I get no errors with this query, but I also get no records back even though I know that records with these attributes exist.

    Maybe something is wrong with this...

    dim fsd
    fsd = FormatDateTime(DateValue(startDate) + TimeValue("0:00"))

    dim fed
    fed = FormatDateTime(DateValue(endDate) + TimeValue("0:00"))

    sSQL = "SELECT * FROM Comments WHERE Name = "&name&" AND Date BETWEEN "&fsd&" AND "&fed&" ORDER BY Date DESC;"

    Also, unless the timevalue is 0:00 or 12am, I get errors in the query.
    Last edited by SteveReinertson; 06-24-2004 at 03:10 PM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules