1 Reply Latest reply on Feb 2, 2011 6:11 PM by RickWhitelaw

    Trying to use the  "find" to select records withing a date range

    yaldir

      Summary

      Trying to use the  "find" to select records withing a date range

      Product

      FileMaker Pro

      Version

      11

      Operating system version

      windows

      Description of the issue

      I have a scheduled events and each one is a multi or a single day event.

      If I have an event scheduled for;

      2/2/2011 - 2/5/2011 for Room 1002
      and if the user trys to schedule another event within the same date range using the same room, I should be able to give en error msg indicating that "room 1002" is not available for the selected date range. I have tried several "Find" logic with no luck.
      I would appreciate if I can gen an example of how to do this within a script.
      warmest regards
      alp

      Steps to reproduce the problem

      there is no issue the the pro 11 I don't think but did not know how otherwise to post, sorry

      Expected result

      I should be able to warn user that ROOM selected within the date range is not available. I will then cancel the script and refresh the screen...