Results 1 to 2 of 2

Thread: Between Dates

  1. #1
    Join Date
    Feb 2003

    Question Unanswered: Between Dates

    How do I in a query, search a field called DATETIME that is general date formatted and get it to display the results for a given time period?

    I, in the criteria field currently have this expression:
    Between [Type Desired Date] And [Type Desired Date With 11:00 PM]
    which works fine but is their a way to just enter in two dates and have the 11:00 PM automatically add to the end of the second variable? Any help is greatly appreciated. B

  2. #2
    Join Date
    Apr 2002
    Suggest you have a look at the function DateAdd.
    See Access Help for examples.


Posting Permissions

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