Hi @stolzj19,
There are a few ways to handle…here’s one:
Because date data types are actually always date AND time we need to select the entire range of time. In the < comparison we set the current date/time to a day forward and then bring it all back to zero’s on the time – this ensures we get everything including the last millisecond of that date. For the >= we are going back to the first millisecond of the current day.