query timeframe?

Results 1 to 2 of 2

Thread: query timeframe?

  1. #1
    Join Date
    Dec 1969

    Default query timeframe?

    I currently have a DB that that contains a smalldattime field.<BR>I wote a query that allows the user to filter by Last 30 Days, Last 60 Days and Last 90 days. That wasn&#039;t aproblem because I could just subtract 30,60,90 from the date field. I now want to change the page that the user can enter in specific dates. Has anyone written or know of any code out there that determines the 2 dates the user entered and selects the correct records?? <BR>thanks

  2. #2
    Join Date
    Dec 1969
    Los Angeles, CA

    Default Use BETWEEN

    R&D how you use that in SQL.<BR><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