Difference between revisions of "Accessing the Current Date in a Report"
Julia Decker (talk | contribs) |
|||
Line 23: | Line 23: | ||
No records will be displayed as no employee was hired in the current year. | No records will be displayed as no employee was hired in the current year. | ||
− | [[Category:Reports | + | [[Category:Reports]] |
Revision as of 13:09, 21 May 2009
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.