5 Replies Latest reply: Aug 15, 2017 10:06 AM by Luigi Miceli RSS

    Set Analysis with dates

    Luigi Miceli

      Hi All,

      this works:

      =count ( {$<AnalysisDate={">=8/9/17"}>} Rate)

       

      this doesn't work:

      =count ( {$<AnalysisDate={"=8/9/17"}>} Rate)

       

      this doesn't work:

      =count ( {$<AnalysisDate={">=$(max(DateTo))"}>} Rate)

       

      *DateTo is a Field, max(DateTo) should give  8/9/17

       

      suggestions?

       

      thanks!

      Luigi