Cognos Analytics

Expand all | Collapse all

XQE-PLN-0267

  • 1.  XQE-PLN-0267

    Posted Tue March 24, 2020 03:52 AM
    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
    ------------------------------


  • 2.  RE: XQE-PLN-0267

    Posted Wed March 25, 2020 05:15 PM
    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
    ------------------------------