A data source may provide date and time information as DATE columns. This format can be mapped to a DATE, a TIME or a DATETIME data type when a column element is created in Information Designer (see Creating a Column Element).
To find the number of days between two DATE columns:
From the Data Sources tree, select two columns of type DATE.
In the Expression field, type the expression %1 - %2.
Comment: By selecting only one column, you can also find the elapsed number of days from today, using the expression sysdate - %1 if you are running against an Oracle data source.
Set the Data type to Integer.
To generate a Spotfire Date column from a DATE column:
From the Data Sources tree, select a column of type DATE.
Set the Data type to Date.
Note: Any SQL arithmetic expression may be entered into the Expression field. However, you need to make sure to use the correct syntax since no validation will be performed. Also note that different databases may have different syntaxes.
See also: