Specifying the parameter format for date, time, and time stamp
When defining reports either using the Dynamic Workload Console, Application Lab 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.