For transfer of parameters for a time filter, when specifying a separator in the formatting instructions, it is assumed that it is a period limited by the two times specified. If no separator is specified, the specified value is interpreted as an absolute period (day, week, month, quarter, year).
The following characters are supported for separating the day, month and year in a filter value:
Characters |
Example |
Note |
. |
24.01.2008 |
The point may be combined with a space, e.g., 24. 01. 2008 |
<Space> |
24 January 2008 |
|
/ |
24/January/2008 |
Slash may not be used as a separator between two times, e. g. |
- |
24-January-2008 |
Minus sign may not be used as a separator between two times. |
The formatting instructions for time filters should not contain any of the special characters full stop, comma, slash, backslash, and minus sign as these characters will be replaced by spaces during the evaluation If this results in several spaces in succession, these will be replaced by a single space.
Ensure that the parameter expression does not contain any unwanted ambiguities in terms of the separator within a time and the selected separator between two times.
The default formatting instructions for filter values specifying time periods are language-specific and identical to the default formatting instructions used in the filter dialogs of the PPM analysis component.
Default formatting instructions for absolute periods
Depending on the language specified when logging in, the following default formatting instructions apply to the interpretation of time filter specifications for absolute periods (day, week, month, quarter, year):
Default formatting instructions for filter values based on days
Language |
Format |
Example |
Effective time period |
German |
dd MM yy |
01.05.07 |
1.5.2007, 0:00 to 1.5.2007, 23:59 |
German |
dd M yy |
1.5.07 |
1.5.2007, 0:00 to 1.5.2007, 23:59 |
German |
dd MMMM yy |
10. May 07 |
1.5.2007, 0:00 to 1.5.2007, 23:59 |
English |
dd MM yy |
01.05.07 |
1.5.2007, 0:00 to 1.5.2007, 23:59 |
English |
dd M yy |
1.5.07 |
1.5.2007, 0:00 to 1.5.2007, 23:59 |
English |
dd MMMM yy |
10. May 04 |
1.5.2007, 0:00 to 1.5.2007, 23:59 |
Default formatting instructions for filter values based on weeks
Language |
Format |
Example |
Effective time period |
German |
'KW'ww yy |
KW10 07 |
5.3.2007, 0:00 to 11.3.2007, 23:59 |
German |
'KW'ww yyyy |
KW10 2007 |
5.3.2007, 0:00 to 11.3.2007, 23:59 |
German |
'KW'ww/yyyy |
KW10/2007 |
5.3.2007, 0:00 to 11.3.2007, 23:59 |
German |
ww 'WOCHE' yy |
10 WOCHE 07 |
5.3.2007, 0:00 to 11.3.2007, 23:59 |
German |
ww 'WOCHE' yyyy |
10 WOCHE 2007 |
5.3.2007, 0:00 to 11.3.2007, 23:59 |
English |
'CW'ww yy |
CW10 07 |
5.3.2007, 0:00 to 11.3.2007, 23:59 |
English |
'CW'ww yyyy |
CW10 2007 |
5.3.2007, 0:00 to 11.3.2007, 23:59 |
English |
'WEEK' ww yy |
WEEK 10 07 |
5.3.2007, 0:00 to 11.3.2007, 23:59 |
English |
'WEEK' ww yyyy |
WEEK 10 2007 |
5.3.2007, 0:00 to 11.3.2007, 23:59 |
Default formatting instructions for filter values based on months
Language |
Format |
Example |
Effective time period |
German |
MM yy |
08/07 |
1.8.2007, 0:00 to 31.8.2007, 23:59 |
German |
MM yyyy |
08 2007 |
1.8.2007, 0:00 to 31.8.2007, 23:59 |
German |
MMM yy |
Okt 07 |
1.10.2007, 0:00 to 31.10.2007, 23:59 |
German |
MMM yyyy |
Okt 2007 |
1.10.2007, 0:00 to 31.10.2007, 23:59 |
German |
MMMM yy |
Oktober 07 |
1.10.2007, 0:00 to 31.10.2007, 23:59 |
German |
MMMM yyyy |
October 2007 |
1.10.2007, 0:00 to 31.10.2007, 23:59 |
English |
MM yy |
08/07 |
1.8.2007, 0:00 to 31.8.2007, 23:59 |
English |
MM yyyy |
08 2007 |
1.8.2007, 0:00 to 31.8.2007, 23:59 |
English |
MMM yy |
Oct 07 |
1.10.2007, 0:00 to 31.10.2007, 23:59 |
English |
MMM yyyy |
Oct 2007 |
1.10.2007, 0:00 to 31.10.2007, 23:59 |
English |
MMMM yy |
October 07 |
1.10.2007, 0:00 to 31.10.2007, 23:59 |
English |
MMMM yyyy |
October 2007 |
1.10.2007, 0:00 to 31.10.2007, 23:59 |
Default formatting instructions for filter values based on quarters
Language |
Format |
Example |
Effective time period |
German |
M 'QUARTAL' yy |
1. Quartal 07 |
1.1.2007, 0:00 |
German |
'Q'M yy |
Q3/04 |
1.7.2004, 0:00 |
German |
'Q'M yyyy |
Q4-1999 |
1.10.1999, 0:00 |
English |
'QUARTER' M yy |
QUARTER 1 07 |
1.8.2007, 0:00 to 31.8.2007, 23:59 |
English |
'Q'M yy |
Q3/04 |
1.10.2007, 0:00 to 31.10.2007, 23:59 |
English |
'Q'M yyyy |
Q4-1999 |
1.10.2007, 0:00 to 31.10.2007, 23:59 |
Default formatting instructions for filter values based on years
Language |
Format |
Example |
Valid period |
German |
yy |
07 |
1.1.2007, 0:00 to 31.12.2007, 23:59 |
German |
yyyy |
2007 |
1.1.2007, 0:00 to 31.12.2007, 23:59 |
If you specify the year with two digits, the previous century is assumed automatically if the resulting year is 80 years in the past. Otherwise, the current century is assumed. If you specify the year with one digit, the constant value 2000 is added.
Example
TIME=2007
Default formatting instructions for discrete periods
If a separator is identified in the formatting instructions, a period limited by the two specified times is assumed. The following default formatting instructions are applicable for specifying the interval limits:
Format |
Example |
Period |
D M yy HH:mm |
1/03/04 14:30-2/03/04 8:29 |
1.3.2004 14:30:00 |
D MM yy HH |
3 04 05 12-5 06 05 15 |
3.4.2005 12:00:00 |
D M yy |
4-07-03/6-08-03 |
4.7.2003 0:00:00 |
ddMMyy HH:mm |
010300 12:00-010300 23:40 |
1.3.2000 12:10:00 |
ddMMyy HH |
070499 8-080499 16 |
7.4.1999 8:00:00 |
ddMMyy |
040506-050607 |
4.5.2006 12:00:00 AM |
D MMM yy HH:mm |
4. Mar 04 7:00-7. Apr 04 14:00 |
4.3.2004 07:00:00 AM |
D MMM yy HH |
6-Jun-01 0/24-Dec-01 23 |
6.1.2001 12:00:00 AM |
D MMM yy |
14/Mar/70-14/Mar/00 |
14.3.1970 12:00:00 AM |
D MMMM yy HH:mm |
4. March 04 7:00- |
4.3.2004 07:00:00 AM |
D MMMM yy HH |
6-June-01 0/ |
6.1.2001 12:00:00 AM |
D MMMM yy |
14/March/70-14/March/00 |
14.3.1970 12:00:00 AM |
Example:
TIME:-=010300 12:00-010300 23:40
User-defined formatting instructions
Characters |
Meaning |
Type |
Example |
G |
Era |
Text |
AD |
Y |
Year |
Figure |
2007 |
M |
Month |
Text or figure |
July or 07 |
d |
Day |
Figure |
10 |
E |
Day of the week |
Text |
Tuesday |
D |
Day of the year |
Figure |
365 (corresponds to 31.12.) |
F |
Day of the week in the current month |
Figure |
2 (unique with day of the week, e.g., second Tuesday in the current month) |
w |
Calendar week |
Figure |
27 |
W |
Week of the month |
Figure |
4 |
Examples:
TIME(yyyyMMdd HHmmss):-=20040101 080000-20040824 173000
TIME(dd MMMM yyyy HH:mm:ss):-=01. January 2004 8:00:00-24. August 2004 17:30:00