Results 1 to 3 of 3
  1. #1
    Join Date
    May 2004
    Posts
    3

    Question Unanswered: Query to show current statuses

    Hi

    I am trying to use a query to get current status of an object
    at the moment my code looks like this
    sql = " SELECT *
    FROM Artefact
    WHERE WhenStatusStart <= #" & Now.Date & "#"
    AND WhenStatusEnd >= #" & Now.Date & "#;"

    this works fine as long as i use the "#" symbols around the date, but it doesn't work if i use timestamps instead dates. ie: use Now instead of Now.date.

    What is the syntax i have to use to make the above query work with timestamps?

    Can anybody help me!!!!

  2. #2
    Join Date
    Feb 2004
    Location
    New Zealand
    Posts
    1,420
    Provided Answers: 7
    Wrong Hat on


    try
    WHERE WhenStatusStart <= #" & Date() & "#"
    AND WhenStatusEnd >= #" & Date() & "#;"

    or
    WHERE WhenStatusStart <= #" & Now() & "#"
    AND WhenStatusEnd >= #" & Now() & "#;"
    hope this help

    See clear as mud


    StePhan McKillen
    the aim is store once, not store multiple times
    Remember... Optimize 'til you die!
    Progaming environment:
    Access based on my own environment: DAO3.6/A97/A2000/A2003/A2007/A2010
    VB based on my own environment: vb6 sp5
    ASP based on my own environment: 5.6
    VB-NET based on my own environment started 2007
    SQL-2005 based on my own environment started 2008
    MYLE
    YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.

  3. #3
    Join Date
    May 2004
    Posts
    3
    thanx Myle but u misread my question

    The query i wrote in the first post works fine...
    but it doesn't work if i use a datestamp variable instead of just a date variable
    what do i have to put around the "Now" to make the query execute

    btw the Now is a VB.NET Fuction, not Access.

Posting Permissions

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