Time Formats
From Alchemex
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 Accpac Intelligence 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 Accpac Intelligence Calendar (shown below) 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 Accpac Intelligence 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. e.g. 19 January 2008 13:15:00 or 19 Jan 2008 13:15:00.
In this way Sage Accpac Intelligence can unambiguously translate the date and time into the format expected by the underlying Database system.