How to set specific month as start date
I need to set last July 1st as the start date for a query. I don't want to hardcode the year, I want at whatever point I run the query for it to look back to the previous July 1st. So today, it would use July 1st 2017, until July 1st 2018, then it would start using that July 1st. I've tried using "first day of last July" but it doesn't recognize that format.