10 Replies Latest reply on Apr 23, 2018 8:19 PM by Shinichiro Murakami

    Date Filter using lookup(attr(date),0) fails in a specific view

    Sankaranarayanan s

      Hi there,

       

      I am using a calculated field to filter the dates.  The calculated field works very well with Big Query. [ Screen shot -1].  However, I apply the same calculated filed in the work sheet which gives me NULL as return value.

       

      Calculated field

       

      Failure image

       

       

      I have tested the filter calculation in a blank work sheet of the same work book which works fine.

       

       

       

      I could not understand this behavior OR I could not fix this.  The view has Week Start date and End date by using Datetrunc function  Event date column is has date& time.   I tried converting the date&Time to pure date only column but still the filter view fails.   

       

       

      Please help.