AnsweredAssumed Answered

Trying to use the "find" to select records withing a date range Product: FileMaker Pro...

Question asked by yaldir on Feb 2, 2011
Latest reply on Feb 3, 2011 by philmodjunk

Post

Trying to use the  "find" to select records withing a date range
Product:
FileMaker Pro
Version:
11
Operating system version:
windows
Description of the challenge:
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
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...

Outcomes