Over time, as more data is edited and entered, I can query this field to check to see which employees' information might be outdated, and request that those employees check and update their information as necessary.In addition to using date functions for controlling and streamlining data entry, Microsoft Access date functions really shine when used as query criteria to filter or limit query results by date or date range.If you find yourself constantly entering whatever today's date is in your Access forms or tables, you are wasting valuable time.Access can do that for you, and you don't have to be an Access expert to do so!
First, we could use the Date Part function to extract both the month and day from a field that stores employees' birthdays.
To limit our query results down to show only those records older than 6 months, we can then tack on a greater than symbol and the number six after the Date Diff function.
Upon saving and rerunning this query, you might notice that Access will display our written expression a bit differently: This is yet another way of expressing the same thing.
Let's say we had a sales table where we only want users to enter a transaction occurring on or before today's date.
We can achieve this level of control by writing an expression in the field's Validation Rule property box inside the table.