KNOWN ISSUE: IT Analytics Reports only accept dates in US format

Article:TECH43170  |  Created: 2009-07-23  |  Updated: 2009-07-23  |  Article URL
Article Type
Technical Solution


Reports containing date parameters fail. The forms accept dates in Australian (or non-US) format dd/mm/yy however the report fails and throws the error:

An error has occurred during report processing. (rsProcessingAborted)
Query execution failed for data set 'PackageServerAvailabilityMonthly'. (rsErrorExecutingCommand)
Execution of the managed stored procedure DateValue failed with the following error: Exception has been thrown by the target of an invocation.Conversion from string "6/22/2008" to type 'Date' is not valid.

Reports identified to incur this issue are:

  • Package Server Availability Daily
  • Package Server Availability Monthly
  • Advertisement Execution Event Summary


IT Analytics 6.0


The date format is hardcoded to be in US format


Symantec is currently investigating this issue.  An update will be made to this article upon completion of investigation.  Those interested are advised to subscribe to this article.

Legacy ID


Article URL

Terms of use for this information are found in Legal Notices