10 Replies Latest reply: Mar 15, 2017 8:55 AM by Phil Speight RSS

    Min & Max Dates GetFieldSelections for report

    Phil Speight

      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