Hi I have the following logic:

   var time1 = new DateTime(2024,08,25)
   var time2 = new DateTime(2024,09,02)

if a table contained a object (we’ll call it ‘A’) with properties:

Start = DateTime(2024,08,25)
End = DateTime(2024,08,25)

the following logic does not return ‘A’ even though it should.

_repo.Get().Where(x => x.Start.CompareTo(time2) <= 0 && time1.CompareTo(x.End) <= 0

But if i do

var compareResult = A.Start.CompareTo(time2) <= 0 && time1.CompareTo(A.End) <= 0

it returns true?
can someone please explain why?