Dynamic Date Ranges For Kace Query in Excel
I'm attempting to use Excel to build dynamic reports and dashboards within Excel for use with the Kace appliance. I've created a series of queries to pull the data I want from KACE. The only bump in the road is all my queries have a set date range, so if I want to change the dataset I have to manually change the date rage for each query. My questions is, does anyone know of a way of taking date ranges from excel cells to dynamically change the date range on the query?