CAML filter with time sensitive comparisons - which time zone is used?

Hello,

I had to use CAML filtering with a time sensitive comparison, although I was 100% sure that what I setup and entered as sample data should return a result for my CAML filter, the CAML filter didn't bring the expected items. So I am guessing it might be again that I am not knowing what time zone is used, is the base the M365 tenant time zone, it it the UTC time or the time zone set at the regional settings of the site the solution is developed on/deployed to that is taken?

Even I have set the filter to ignore the time, there were no results showing...

Example:

I am trying to filter out list items having a reporting date "Today" (April 30^th 2024) excluding time using "Equals":

When I "Run" the query I do not get any result:

However, when I do set "Greater than or equals"

I do get a result:

But you see that the "Report Date" is "Equal" to "Today", I also played with "Equal" and the "offset for today" but nothing what I tried was bringing the match that was definitely there. So my question is, why is the filter not bringing the result - although it should ignore the time, is it because of any time zone the site is set to and I was just not making my test at a time where "Today" was still returning not my today? Or is there a bug I am not aware of? Am I doing it wrong?

Many thanks! Cheers
Joerg

Search

CAML filter with time sensitive comparisons - which time zone is used?

Comments