2 Replies Latest reply on Nov 29, 2012 11:39 AM by GregMcGrath

    Validating Dates in an Event Management Database



      Validating Dates in an Event Management Database


           I have created an Event Management database to manage events within a Conference and Arts Centre.

           I want to be able to have a screen where a user enters a start and end date to call up pre-booked events within that range to ensure that we do not double book a venue.

           I started out by building a calculation: "Match Date" where Date ≥ Start Date and Date ≤ End Date. Start and End dates are global fields in the Diary file.  I then created a Calc field that is called "Matching Dates" which is simply a calculation that returns  "1"

           I then created a relationship between the Original "Diary" file and a "Diary 2" file (same file) linking the "Match Date" calculation with the "Matching Dates" field. 

           I created a new layout with the Diary as the primary file and "Diary 2" as the list of fields for the portal. However it does not work. When I enter the start and end dates it returns nothing.

           I am stumped and looking for help.