Trying to use the "find" to select records withing a date range
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.
there is no issue the the pro 11 I don't think but did not know how otherwise to post, sorry
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...
I would post this on the FM Pro Forum. You're more likely to get help there. This particular forum is for reporting issues with FMP itself (bugs).