2 Replies Latest reply: Aug 30, 2018 5:39 AM by Mike Slade RSS

    Set Analysis GetFieldSelections with date problem

    Mike Slade

      Afternoon all  

       

      Need a little guidance to get this working, being trawling questions and can't get this to work.  I'd like to use getfieldselections in the calculation.

       

      This works:

      Count({<WeekEnding ={'05/08/2018'}>}distinct ID)

       

      I want to replace '05/08/2018' to work off a filter pane of a field called StartDate

       

      Something like this:

       

      Count({<WeekEnding ={date#(GetFieldSelections('StartDate'),'DD/MM/YYYY')}>}distinct ID)

       

      Anyone able to help?

      Thanks in advance.