I have a query that looks for dates older than 06/04/2017. So far so good. But to avoid changing the year each, I want the query to to have the date 06/04/yyyy where yyyy is the year the query is being run. I thought it would be easy, but it’s not something I’ve needed to do and I can’t see how to do it. It’s a query that gets run once a year so we have to remember to change the year.
Eliminate spare time: start programming PowerShell