Results 1 to 3 of 3

Thread: SQL for date. Help

  1. #1
    Guest

    Exclamation

    Hi,
    How can I perfom an SQL search filtering the date?

    Dim DateFrom, DateTo as Date

    data1.recordsource "SELECT * FROM database WHERE Date Between ?????????? "

    Thanks!

  2. #2
    Addicted Member CoMMiE's Avatar
    Join Date
    Jul 2000
    Location
    Malaysia, Kuala Lumpur
    Posts
    179

    Cool

    Hi

    Code:
    strDate = Format(Text2.Text, "dd/mm/yy")
    strdate2 = Format(Text3.Text, "dd/mm/yy")
    
    Data1.RecordSource = " select * from customerpricelist  where date  between #" & strDate & "# and #" & strdate2 "#"
    Data1.Refresh
    Hope that answer your question

  3. #3
    Guest

    Thumbs up

    Thank 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
  •  



Click Here to Expand Forum to Full Width