comparing dates

Results 1 to 2 of 2

Thread: comparing dates

  1. #1
    Join Date
    Dec 1969

    Default comparing dates

    I am trying to only pull information from a database if it meets the requirements of two conditions, but when I use both conditions I receive an error message. The following is the code I am using:<BR><BR>SQL = "SELECT * FROM events_calendar where date = " & date & "AND type = 1" & "ORDER BY date asc"<BR><BR>What do I need to change? thanks

  2. #2
    Join Date
    Dec 1969

    Default RE: comparing dates

    Try changing the field name in your database from date to datDate. I ran into a similar problem because date was a reserved keyword and doing this solved it. Hopefully it helps.

Posting Permissions

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