In the previous post, Fun With KQL – DateTime Arithmetic, we had hard coded a date for the start of the year, in order
tofind out how much time had elapsed between it and datetime columns. I had mentioned there are ways to dynamically calculate such values.
In this post we’ll look at one way, using the
StartOf...functions. These include
Read on to see how they all work.