Welcome!

This community is for professionals and enthusiasts of the Genio platform.
Share your questions and challenges, and help your partners!

1

0
Tiago Xavier
On 11/21/19, 4:28 PM

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:

iif(ComparaDatas(iif([DTEX->DTSTARTA] > [DTEX->DTSTARTB], [DTEX->DTSTARTA], [DTEX->DTSTARTB]), iif([DTEX->DTENDA] < [DTEX->DTENDB], [DTEX->DTENDA], [DTEX->DTENDB])) <= 0, 1, 0)

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

This platform is for beginners and experts willing to share their Genio knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers. Read Guidelines

Question tools

14 follower(s)

Stats

Asked: 11/21/19, 3:16 PM
Seen: 1598 times
Last updated: 11/26/19, 10:09 AM