Hi,

We have form  with dropdown field "Studio" with options {Studio 1, Studio 2, Studio3} and date-time field "From" & "To", so suppose if I book ( ID 46 ) a studio from "15-Aug-2021 10:45" to "15-Aug-2021 12:45" with studio selected as "Studio 2" then b/w this time interval no duplicate entry should happen when studio is also same but if time is same and studio is diff. new entry can take place.

In below screenshot request-ID 43 & 47 should not have been successfully submitted because time interval matches & studio is also same, so both of these should have shown alert while submitting record.

I was able to write check for same-time & same-Studio for Same-Day meaning if 2 entries that are to be compared have the day-in-dates same (say both entry are happening for today then 7th - Aug is same for both), but when one is 7th other is 8th or one is 6th and other is 7th the check gets failed when I try to compare time. (ID 43 and 46 for reference ).