Overlaping date range workflow logic help

I need help in identifying overlaps in the invoice data I have entered.
In my scenario, I have an invoice data entry form with invoice no period from, period to and amount. My table structure is

Now when I submit the data I have data successfully going in.

However I need help with another flow where when user Submits the form the data goes in and also flags an Overlapping error message if there are other invoices within Same Period From and Period To date ranges for that customer only

Any help will be highly appreciated.
Thanks in advance

This topic was automatically closed after 70 days. New replies are no longer allowed.