Skip to Content

The following objects cannot be used as query filters: Year(GetDate())-1 following upgrade

May 15, 2017 at 04:56 PM


avatar image


Upgraded an environment from 4.1 SP3 to 4.2 SP3 Patch 6.

In 4.1, there are a handful of reports that use a filter in a WebI report, such as

Fiscal Year Greater than or Equal to year(getdate())-1

This worked in 4.1, but in 4.2, while refreshing the data in 4.2 and editing the report to validate the query, the following error is returned:

The following objects cannot be used as query filters year(getdate())-1. Contact your administrator. (Error: INF).

This only worked before while creating a report in the WebI Rich Client, but the data was able to be refreshed in the Web Interface, just not modified. In 4.2, it can't be refreshed.

Is this a bug in 4.2 SP3?

Thank you,


10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers