Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all
I want to show the dates selected in a report but when I put the selections in the report it show 11 of 45 for months.
I have managed to create an expression which I can add to a text box and show the selections below :
=GetFieldSelections(Month, '; ', 100) & ' | ' & GetFieldSelections(Division)
This shows all dates selected. and shows the Different Divisions
Apr 2015; May 2015; Jun 2015; Jul 2015; Aug 2015; Sep 2015; Oct 2015; Nov 2015; Dec 2015; Jan 2016; Feb 2016; Mar 2016; Apr 2016; May 2016; Jun 2016; Jul 2016; Aug 2016; Sep 2016; Oct 2016; Nov 2016; Dec 2016; Jan 2017; Feb 2017; Mar 2017; Apr 2017; May 2017; Jun 2017; Jul 2017; Aug 2017; Oct 2017 | North Division
Is there a way I can adapt this so that it only shows Min date & max date so that I can show the following
Dates : Apr 15 to Oct 17
North Division
Many thanks
Phil
All great. Thanks All