Time Formats

Home > Connector > Maintaining the Connector > Time Formats

Time Formats with Dates

By default when filtering and paramatizing reports, Date and Date Time fields are treated as Dates only. This is, since commonly information in Databases is stored by date and the time component is deemed insignificant.

In certain situations it is necessary to paramatize on the Date and the Time. To force Sage Intelligence Reporting to pass full Date and Time values to the underlying database system you must check on the advanced property Use Time with Dates option on the specific connection in the Connector. If you do this all Dates will be passed through to the Database as Date and Time for reports belonging to the connection. Additionally the Sage Intelligence Reporting Calendar that is used in report parameterization will include a Time selection option.

Selecting Date Times in Report Parameters

It is preferable to use the Sage Intelligence Reporting Calendar when selecting Dates Times in Parameters. If you prefer to key in Date Time values for a Report Parameter or Filter it is best to use the format dd mmm yyyy hh:mm:ss to avoid ambiguity and Date errors. for example, 19 January 2008 13:15:00 or 19 Jan 2008 13:15:00.

In this way Sage Intelligence Reporting can unambiguously translate the date and time into the format expected by the underlying Database system.