3 Replies Latest reply: Dec 4, 2012 8:09 AM by Roberto Postma RSS

    Quick Set Analysis Question

    Darren Johnson

      I am using this set expression...

       

      [FirstDate Date]=,[FirstDate Day]=,[FirstDate Weekday]=,[FirstDate Year]=,[FirstDate Month]=,[FirstDate Quarter]=,[FirstDate _MonthSerial]=,[FirstDate _QuarterSerial]=,[FirstDate _WeekSerial]=,[FirstDate Year-Month]=,

      [FirstDate Date] = {"<=$(=AddYears(Max([FirstDate Date]), -1))"},

      [FirstDate Date] = {">=$(=AddYears(Min([FirstDate Date]), -1))"}

       

      It's supposed to give me records related to the currently selected date range minus 1 year. But it is bringing back the whole year. I need the equivalent of a logical AND...

       

      Any ideas?

       

      Thank you