Omitting an entry based on if a date entry is more than two weeks earlier
I'm helping a friend make a script for his work's database. I literally started working with this program this evening. This site has helped me a lot in learning how to make scripts. Unfortunately I've run into a snag in my searching where I can't quite find a clear answer.
We have an attribute called 'Date Received' and it is in m/d/y format. I've created a button that searches for only a certain attribute (In this case they need all entries with 'pass' to be viewed. This is unrelated to the problem.) However they only want entries with 'pass' to show up if the 'Date Received' is less than two weeks from the current date.
I've found similar solutions but so far what I've found is unclear as far as where to put the scripts. Ideally, could somebody explain step by step how I would check two weeks earlier from the current date and omit those that are older?
Thank you in advance.