Accessing the Current Date in a Report

You will sometimes need to create reports that use the current year, month, or day. To build these types of criteria, you will need to use the Date/Time Translation setting, in conjunction with special criteria that retrieve the current date in a specified format.

1. Copy the report Employee Start Dates to a new report Employee Start Dates - Current Year.

2. Display the Report Builder.

3. Click the Date Comparisons tab in the bottom half of the window.

These expressions are used in the criteria to automatically display dates

These functions are used to extract specific types of times from a date field. For example, the current year.

4. Modify the Date Criteria to look as follows:

5. Build, save, and preview the report.

No records will be displayed as no employee was hired in the current year.