Date Fields
The following date fields in the data dictionary provide a means to display information about an issue, calculated from when the issue was initially created.
| Field Name | Title | Definition |
| DAYS_OPEN | Days Open | The number of days that an issue has been in a status that is not closed. The closed status is defined by the setting of the behavior setting named STATUS_CLOSED_NAME. The result is rounded to the nearest day. |
| WEEKS_OPEN | Weeks Open | The number of weeks that an issue has been in a status that is not closed. The closed status is defined by the setting of the behavior setting named STATUS_CLOSED_NAME. The result is rounded to the nearest week |
| MONTHS_OPEN | Months Open | The number of days that an issue has been in a status that is not closed. The closed status is defined by the setting of the behavior setting named STATUS_CLOSED_NAME. The result is rounded to the nearest month. |
| SYSDATE | Current Date | This is a Special Variable Field. When this is encountered within a date field within a query, in the form $$SYSDATE$$, ExtraView will substitute the current date, complete with the current time. This allows users to compose and save queries that have a range to or from the present date. |
| SYSDAY | Current Date | This is a Special Variable Field. When this is encountered within a date field within a query, in the form $$SYSDAY$$, ExtraView will substitute the current date, without time. The time is set to 00:00. This allows users to compose and save queries that have a range to or from the present date, as of midnight. |
Date Range Fields
The date fields within the ExtraView database have an extra field defined in the data dictionary that works in conjunction with the date. This additional field works as a filter on ExtraView report screens, allowing reports to be defined that will select results based on a number of days since the date.
The date fields and the additional field are:
| Data dictionary main field | Data dictionary additional field | Comment |
| DATE_CREATED | DATE_CREATED_SINCE | Days since the issue was created |
| TIMESTAMP | TIMESTAMP_SINCE | Days since the issue was last updated |
| DATE_LAST_STATUS_CHANGE | DATE_LAST_STATUS_CHANGE_SINCE | Days since the issue’s last change of status |
| DATE_CLOSED | DATE_CLOSED_SINCE | Days since the issue was closed |