Specifying the parameter format for date, time, and time stamp
When defining reports either using the Dynamic Workload Console, or composer, specify parameters of type date, time, and time stamp, using a specific syntax.
The following table shows the syntax you must use when defining reports
containing date, time, and time stamp formats as parameters.
Prompt type | Cognos® parameter format | Cognos® parameter format examples | ||
---|---|---|---|---|
Single value | List of values | Interval values | ||
Date | CCYY-MM-DD | 2012-02-03 | 2012-02-03-Value:2012-03-14 | Between 2012-02-03 and 2012-04-15 |
Time | hh:mm:ss | 01:00:00 | 01:00:00-Value:01:01:01 | Between 01:00:00 and 23:59:30 |
Time Stamp |
|
|
2012-02-03 15:05:00-Value:2012-02-03T16:01:00-Value:2012-02-03T16:00:00 |
|
Note: You must specify the parameter format exactly as they are shown in the table
respecting lower case and upper case formats.