1 Reply Latest reply on May 23, 2016 8:51 PM by makin

    filter with date session variables

    3193829

      Hi

      I have a  date column whose data type is DATETIME, I am using Filter condition in BMM to filter out a dimension with the date session variable but i am getting error "[nQSError: 22024] A comparison is being carried out between non-compatible types.".

       

      my logic is  Filter(paint."sales"  Using  paint.dates = VALUEOF(NQ_SESSION.App_Date_8))

       

      I have duplicated the dates column and made the data type to DATE but it didnot help.

      how can the metrics be filtered using date session variable.

       

      Regards,

      Kalpana