Show TOC

Function documentationDate Range for Queries Locate this document in the navigation structure

 

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:

  1. Schedule

  2. Time Period

  3. Time

  4. 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 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 Note

This parameter is relevant only for Tag and PCo queries.

End of the note.