4,401
edits
Changes
no edit summary
You can manipulate dates within a report in two ways:
* Display dates in date specific formats. This is done using the '''Date/Time Translation''' combo box below the field name.
[[Image:Reps50.png]]
In this example, the year will be displayed from the date.
* Set date criteria to select records based on the dates.
You may need to combine these techniques to get the types of reports that you require.
For example, if you wish to list all the employees hired in a specific year and only show the year (not the date), you could translate the date format to only display the year, and then set a criteria to the value of that year.
If you wished to show the actual date, then you would have to set two date criteria representing '''1-January''' and '''31-December''' of the year.
In the following example, you will be using employee data that includes an employee start date field.
1. Click the '''New Report''' tab.
2. Add the following report details:
[[Image:Reps49.png]]
3. Select the '''User''' table.
[[Image:Reps48.png]]
The [[User|user]] table provides access to all [[Internal|internal]] people, as well as any [[Custom Fields|custom fields]] associated with [[Internal|internal]] people, and associated [[Role|role]]-based fields.
In this instance, there are two [[Custom Fields|custom fields]]: The salary and the start date.
4. Click the '''Save''' button.
5. Click the '''Report Builder''' button.
6. Add the following fields:
[[Image:Reps47.png]]
7. Click the '''Build Query''' button.
8. Click the '''Save''' button.
9. Click the '''Preview''' button.
All records are displayed.
[[Image:Reps46.png]]
The date is displayed in the default format of year, month, and date.
It is always a good idea to ensure that the basic query returns some results before applying criteria.
10. Close the '''report''' and '''parameter''' window.
11. Click the '''Report Builder''' tab.
[[Category:Reports]][[Category:System Management]][[Category:Applications]]
* Display dates in date specific formats. This is done using the '''Date/Time Translation''' combo box below the field name.
[[Image:Reps50.png]]
In this example, the year will be displayed from the date.
* Set date criteria to select records based on the dates.
You may need to combine these techniques to get the types of reports that you require.
For example, if you wish to list all the employees hired in a specific year and only show the year (not the date), you could translate the date format to only display the year, and then set a criteria to the value of that year.
If you wished to show the actual date, then you would have to set two date criteria representing '''1-January''' and '''31-December''' of the year.
In the following example, you will be using employee data that includes an employee start date field.
1. Click the '''New Report''' tab.
2. Add the following report details:
[[Image:Reps49.png]]
3. Select the '''User''' table.
[[Image:Reps48.png]]
The [[User|user]] table provides access to all [[Internal|internal]] people, as well as any [[Custom Fields|custom fields]] associated with [[Internal|internal]] people, and associated [[Role|role]]-based fields.
In this instance, there are two [[Custom Fields|custom fields]]: The salary and the start date.
4. Click the '''Save''' button.
5. Click the '''Report Builder''' button.
6. Add the following fields:
[[Image:Reps47.png]]
7. Click the '''Build Query''' button.
8. Click the '''Save''' button.
9. Click the '''Preview''' button.
All records are displayed.
[[Image:Reps46.png]]
The date is displayed in the default format of year, month, and date.
It is always a good idea to ensure that the basic query returns some results before applying criteria.
10. Close the '''report''' and '''parameter''' window.
11. Click the '''Report Builder''' tab.
[[Category:Reports]][[Category:System Management]][[Category:Applications]]
