You might try DATEPART(interval, date). There's other syntax within each of the interval and date that you can use to pin-point your work. At least maybe that's a helpful starting point. 🙂
Tim N. Lansweeper Employee
Reports & Analytics
Ask about reports you're interested in and share reports you've created. Subscribe to receive daily updates of reports shared in the Community.
