You can display the newest, oldest, or next date value in a list of search results, or display the total number of dates in the past or dates in the future. To add a statistic for a date value, complete the following steps.
Before you can add a statistic for a date custom
property value, you must first add the custom property column to
the view.
-
Access the view preview using
one of the following methods.
Situation Steps Create a date statistic for a view - Open the view in View Designer.
- In View Designer, click View > Preview.
Create a date statistic for a container content view - In Management Console, in the left pane, select Folder Types.
- In the right pane, select the folder type and click Modify.
- In the Folder Type dialog box, on the Appearance tab, click the Preview button.
Create a date statistic for a workflow queue view - Open the workflow process in Workflow Designer.
- Double-click the queue to open the Queue Properties window.
- In the Queue Properties window, in the left pane, select Appearance.
- In the right pane, click Preview.
Create a date statistic for a workflow process view - Open the workflow process in Workflow Designer.
- Click File > Properties.
- In the Process Properties dialog box, under Appearance, click Preview.
- In the Preview pane, click the Statistics button.
- In the Statistics dialog box, click Add.
-
Under Label, type a label that
describes the statistical function to appear in the search results grid.
If adding a statistic to view the next task due date, type Next task due.
- Under Column, select the view column with the date values.
-
Under Function, select one of
the following options depending on the display variable you want
to show:
Situation Steps Total number of dates in the future - Select Count Future.
Total number of dates in the past - Select Count past.
Oldest date value - Select First.
Newest date value - Select Last.
The next future date - Select Next.
The most recent date - Select Previous.
-
Optional. Under Caption, select
the value to display when the statistic only applies to one search result.
If a Previous statistic shows the last viewed item, and you want to quickly display the user name of the user who viewed the item, you can use the Caption column to select the Last Viewed By user.
- Optional. To reorder the statistic, click the Move Up or Move Down button until the statistic reaches the desired position.
-
Click OK.
The statistic appears below the grid in the Preview pane.
- In the Preview pane, click the Run button to test the statistic's performance.