UDA-SQL-0219 The function "_end_of_month" is being used for local processing

[gosoccer]

Hi folks,  :) (Relational) Report Studio

The report runs but when I perform a Query - View Tabular Data in Report Studio, I get the following error from one of my
functions I'm using for getting the End of Month value,.

UDA-SQL-0219 The function "_end_of_month" is being used for local processing but is not available as a built-in function, or at least one of its parameters is not supported.

Here is the code I'm using in a Data Item, going after any records that falls between the first of the month and end of the month.

[Presentation View].[XXXX_DATE]>=_first_of_month ([Presentation View].[XXXX_DATE]) and [Presentation View].[XXXX_DATE]<=_end_of_month ([Presentation View].[XXXX_DATE])

UDA-SQL-0219 The function "_end_of_month" is being used for local processing but is not available as a built-in function, or at least one of its parameters is not supported.

Any suggestion or help would be greatly appreciate it. 8) 8)

[BigChris]

Is _end_of_month correct? When I look in RS the function for me is _last_of_month

[cognosguru]

I agree BigChris, I don't believe there is _end_of_month it is _last_of_month Cognos function.

[MFGF]

[Presentation View].[XXXX_DATE]>=_first_of_month ([Presentation View].[XXXX_DATE]) and [Presentation View].[XXXX_DATE]<=_end_of_month ([Presentation View].[XXXX_DATE])

UDA-SQL-0219 The function "_end_of_month" is being used for local processing but is not available as a built-in function, or at least one of its parameters is not supported.

Any suggestion or help would be greatly appreciate it. 8) 8)

Oh dear. While I agree it would be nice if IBM built cognitive capabilities into the query engine that could determine your meaning whatever you type in to your expression, sadly that's not the case. You can't just make up your own function names and expect them to be legal syntax :)

The error message explains exactly what the issue is here. You have used a function _end_of_month() that isn't recognised. As BigChris and cognosguru pointed out, the function you need is _last_of_month(). You can easily make sure you are using appropriate functions when building your expressions simply by browsing the Functions tab in the expression editor.

Cheers!

MF.

[gosoccer]

Resolved. Thanks everyoine