Results 1 to 2 of 2

Thread: like?

  1. #1
    Join Date
    Dec 1969

    Default like?

    I haven&#039;t had much experience working with dates and Access so I need some help. I checked the FAQ&#039;s under dates and times but no info for this.<BR><BR>I need to pull the records from an access db that has records with a short date. eg:8/28/01 I have a link displayed that will send a month such as nextpage.asp?month=8 I need the syntax for a select statement that will pull all of the records for 8 or August. I think it has to be a like statement but I don&#039;t know the correct syntax.<BR><BR>Thanks

  2. #2
    Join Date
    Dec 1969

    Default RE: like?

    SELECT * FROM Tbl WHERE DatePart(Month,DATE_FIELD) = 8<BR>

Posting Permissions

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