An API that connects multiple Microsoft services, enabling data access and automation across platforms
Graph query using a datetime range?
I have need of doing a graph query for a number of items that have a starttime and endtime each. These items might start at 23:00 and end at 5:00 the next day.
If I am querying for today's items, I would logicially query for midnight (zero hour) today and end time of 23:59:59 to get the whole day.
but when I query for items that have a starttime (at zero hour), they are obviously not going to be included even though their end time is clearly within range.
and I'm told you can't have the same field used in a query twice.
Is it possible to filter twice?
or is there another way to get the items that pertain to the particular day?