Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2003
    Posts
    138

    Unanswered: Search two fields for dates

    I have an absentee database that needs a report to show absentees from that day forward.

    I.E. John Smith called off on 3/12/2012
    - he is off indefinitely - they enter an end date of 12/31/2012

    My report needs to search the two fields - Start Date and End Date to find all of the dates that are equal to today and every day in between.

    In other words, John smith needs to stay on this list until he returns to work. Thanks!

    Thanks!

  2. #2
    Join Date
    Dec 2003
    Posts
    138
    Solved my own issue by simply searching the end date field for any date that was greater than or equal to today. Maybe it will help someone else. Thanks.

    >=Date()

Posting Permissions

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