You use the Date Range screen to assign parameters for SAP Manufacturing Integration and Intelligence (SAP MII) time-sensitive queries. In tag and alarm queries, the date filter is applied to the Time column. In a SQL query, the date filter is applied to the DateColumn, which is set on the SQL Query Details screen.
Note
SAP MII supports the Gregorian calendar only.
The priority of the date selections is as follows:
Schedule
Time Period
Time
Start Date and End Date
The following table describes some of the date range parameters:
Parameter | Description |
---|---|
Start Date and End Date | Used to enter start and end dates. A calendar is displayed to select the dates. You can de-select the dates by choosing Clear button |
Date and Time Format | Select the date and time format from the drop-down list. |
Duration | Used when the Time parameter is used or whenever one or both of the Start Date and End Date parameters are not provided |
Duration Units | |
Time | Defines the time |
Time Period | Specifies the time period |
Schedule | Based on the configuration, the current shift and previous shift are determined by the system and the appropriate time period parameters are used in the query. You must select either CurrentShift or PreviousShift time period. The default is CurrentShift. |
Allow Future Dates | Resets the AllowFuture query parameter. Note If your end date is set to a future date, you can change it to the current date and time of the server. Therefore, you can review a Shift to Date or Week to Date query without using the full duration and the chart uses the entire x-axis to show data. End of the note. |
Interval Count | Divides the overall query time into even segments Note This parameter is relevant only for Tag and PCo queries. End of the note. |