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
Activé 21/11/2019 16:28

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: 21/11/2019 15:16
Seen: 1584 times
Last updated: 26/11/2019 10:09