Hi All,
I have modified my curent report package and when I refreshed that my report showing
XQE-PLN-0267 this error for to_date function.
XQE-PLN-0267 The argument at position 1 of the function 'to_date' is invalid in filter/slicer expression 'to_date([Business View].[DIM_DT].[CLNDR_DT], 'YYYY-MM-DD')between _first_of_month(_add_months(current_date,-1)) and _last_of_month(_add_months(current_date,-1))' of query 'Summary Query', expected one of the following types: 'string, integer'.
XQE-PLN-0267 The argument at position 1 of the function 'to_date' is invalid in filter/slicer expression 'to_date([Business View].[DIM_DT].[CLNDR_DT], 'YYYY-MM-DD')between _first_of_month(_add_months(current_date,-1)) and
_last_of_month(_add_months(current_date,-1))' of query 'Summary Query', expected one of the following types: 'string, integer'.
Can anyone please help me on this.
------------------------------
Priyanka Joshi
------------------------------