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.