I have to hold my hands up and say I didn’t know you could do this and was pleasantly surprised I found something I could share even if it was from my 12yr old. This is not a SQL tip but a productivity tip which will save me loads of time. I had downloaded a file yesterday which was in a sub folder and I asked him to find it , how he did it surprised me
When you type date: into the search box as shown below, it brings up a calendar which when you click on it brings up the files modified that day, even though it was in a sub folder genius! You can even quickly find things from earlier in the week or last week with one click