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 30th 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"
Many thanks! Cheers
Joerg
Please sign in to leave a comment.
Comments
0 comments