Date Range for Queries

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 Note

SAP MII supports the Gregorian calendar only.

End of the note.

Features

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.