Set Analysis GetFieldSelections with date problem

[mikeslade]

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.

[sunny_talwar · Accepted solution]

Try this

Count({<WeekEnding ={"$(=Date(Max([StartDate]), 'DD/MM/YYYY'))"}>} DISTINCT ID)

[mikeslade]

Thank you! Apologies for the delay in response!