I would troubleshoot this by testing subsets of the full expression one at a time via new calculations.
e.g, test the
'to_date([CLNDR_DT], 'YYYY-MM-DD') without the rest to narrow down where the problem is.
It's likely resolved by tweaking the syntax.------------------------------
Jason Tavoularis
------------------------------
Original Message:
Sent: Tue March 24, 2020 03:51 AM
From: Priyanka Joshi
Subject: XQE-PLN-0267
XQE-PLN-0267 The argument at position 1 of the function 'to_date' is invalid in filter/slicer expression 'to_date([CLNDR_DT], 'YYYY-MM-DD')between _first_of_month(_add_months(current_date,-1)) and _last_of_month(_add_months(current_date,-1))'
I am getting this error while replacing exsting packages,actually new package contains just changed views
------------------------------
Priyanka Joshi
------------------------------
#CognosAnalyticswithWatson