Setting Date Range in Query Builder
Hi, I am trying to expand on my work order queries for my water and wastewater plants. For my dashboards, I would like to have a row across the top of the page that has counts of work orders 90 Plus days past Projected Start Date, 60-90 Days Past Projected Start Date, 45-60 Days Past Projected Start Date, 30-45 Days Past Projected Start Date. I cannot figure out how to enter those dates into the Query builder to make them be relative to the current date. Any help would be great!
