2 Replies Latest reply: Aug 1, 2013 3:50 AM by imadscot RSS

    Expressionless Expressions

      I am trying to extract data from a table and count the result.  I am using a Chart/Pivot Table to do this.  The expression runs:

       

       

       

       

       

       

       

       

       

       

       

       

      This is giving me a blank table when I am expecting results (I am querying the data using another method so that I can check whether the result is what I expect).

       

       

       

      If I just put in the expression for the start date I get a result but not the end date.  What have I missed? There are dates in the table that meet these criteria

       

       

       

       

      = sum(if(Field1 < 4 and date(start,'yyyy-MM-dd') <= today() and date(end,'yyyy-MM-dd') > today() ,1,0))