Skip to main content
Question

Overlapping dates

  • September 5, 2019
  • 0 replies
  • 118 views

I have an out of office table. I need to check that new records don't overlap with existing records. Any way to do this natively?

The most recent post on this I could find was from 2017, and it pointed to an AJAX solution, not a native one. 




------------------------------
Nathaniel Cahill
------------------------------
This topic has been closed for replies.

Hi Nathaniel, I have been looking to create an overlapping report based on date/time fields as well. 
Is there a function in QB that can reproduce the same results of the SUMPRODUCT excel formula?

Sadly, I have not found a solution yet...

------------------------------
Francesco Spiga
------------------------------