Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2003
    Location
    Penang, Malaysia
    Posts
    212

    Unanswered: What is the Access SQL command for GetDate() in SQL?

    I'm writing a ASP program . And want to show only records
    that are later then today's date.

    e.g.
    Code:
    sSQL = " Select * from  Show where ShowDate > '"&Date&"'"
    The &Date& is an ASP specific command, however the code has error.
    Can someone show me the correct why of wrinting Access SQL command for that specific purpose..TQ
    Patrick Chua
    LBMS ( Learn By My Self) NPQ ( No paper Qualification )

  2. #2
    Join Date
    Oct 2003
    Location
    Ger
    Posts
    1,969
    Provided Answers: 1
    Try
    sSQL = " Select * from Show where ShowDate > 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
  •