Welcome!
This community is for professionals and enthusiasts of the Genio platform.
Share your questions and challenges, and help your partners!
Limiting new table record: How to make a write condition that checks the interval between 2 dates?
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.
Keep Informed
About the Community
Question tools
Stats
Asked: 21/11/2019 15:16 |
Seen: 1584 times |
Last updated: 26/11/2019 10:09 |