Results 1 to 2 of 2

Thread: Between Dates

  1. #1
    2 Star Lounger
    Join Date
    Dec 2002
    Posts
    192
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Using this criteria --Between[Enter Begin Date:] And [Enter End Date:] --you have to enter Start and End Date which is what we want most of the time, But sometimes we want all the dates so we just hit Enter when it ask for the Begin Date and Enter when it ask for the End Date but this does not work. We don't always know the Start Year or date.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    You could use

    (>=[Enter Begin Date:] Or [Enter Begin Date:] Is Null) And (<=[Enter End Date:] Or [Enter End Date:] Is Null)

Posting Permissions

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