AnsweredAssumed Answered

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

Question asked by yaldir on Feb 2, 2011
Latest reply on Feb 2, 2011 by RickWhitelaw

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...

Outcomes