I have the tables PERSON (field: name) and LOCPERSON (fields: foreignkeyPERSON, local, begindate, enddate), which I want to use to know where the person was at any given date.
How do I make sure that a person is not at 2 locals at the same time? i.e. when I create a new record in LOCPERSON, how do I make sure I'm not inserting the same person at another local in the same time interval of an already existing record with that person?
Here is one example where I have one period with fields "DtStartA" and "DtEndA", and other period with fields "DtStartB" and "DtEndB".
Another field will be check formula with name "check" like you can see were:
With that example you can make a arithmetic formula like this:
The return on this example will be logical and is true when you have conflit between two period of dates.
About This Community
|Asked: 11/21/19, 3:16 PM|
|Seen: 291 times|
|Last updated: 11/26/19, 10:09 AM|