Specifying the parameter format for date, time, and time stamp

When defining reports either using the , 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.
Table 1. Examples to use for parameters of date, time, and time stamp formatsTable with examples to use for parameters of date, time, and time stamp formats
Prompt type parameter format 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 
CCYY-MM-DDThh:mm:ss
or
CCYY-MM-DD hh:mm:ss
 
2012-02-03
 15:05:00
 2012-02-03 15:05:00-Value:2012-02-03T16:01:00-Value:2012-02-03T16:00:00 
Between 2012-02-03 15:05:00
 and
 2012-04-15T16:00:00
Note: You must specify the parameter format exactly as they are shown in the table respecting lower case and upper case formats.