Grabbing records between two dates

Results 1 to 4 of 4

Thread: Grabbing records between two dates

  1. #1
    Raleigh Guest

    Default Grabbing records between two dates

    I need to grab all records between two dates in a database - How can I handle this in my select statement?<BR><BR>I.e. :<BR>I want to select all dates in a database between 1/15/01 and 1/20/01 - How do I handle the "between".<BR><BR>Thanks!!

  2. #2
    MetaMorphic Guest

    Default RE: Grabbing records between two dates

    I am rather new at this, but in sql you use<BR><BR>Select * from table<BR>Where date between &#039;1-15-01&#039; and &#039;1-20-01&#039;<BR><BR>

  3. #3
    Raleigh Guest

    Default Formatting dates

    That worked great except that - The two numbers are session variables from a text box. I tried Cdate() to format them as dates but it doesn&#039;t seem to work. Any Idea how I should handle this?<BR><BR>Heres my select:<BR>Psql = "select * from jobs where jobdate Between "& datefrom &" And "& Dateto &""

  4. #4
    Metamorphic Guest

    Default RE: Formatting dates

    Could you show me what the output is that it gives you

Posting Permissions

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