How to use Date in WHERE

Results 1 to 2 of 2

Thread: How to use Date in WHERE

  1. #1
    Join Date
    Dec 1969

    Default How to use Date in WHERE

    I am trying to Instr$ the three letter month from a medium date type field record set in a SQL statement to create a report that is selected by monthly sales. I&#039;ve tried Instr$, converting it with CStr. I tried Left$, with a short date type.<BR>Is this possible?

  2. #2
    Here's how... Guest

    Default RE: How to use Date in WHERE

    Example<BR>SELECT * From tblOrderDetail <BR>WHERE Month(DateFieldName) = &#039;" & strVariable & "&#039;

Posting Permissions

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