2 Replies Latest reply: Sep 19, 2017 3:43 AM by Charles Penprase RSS

    How do i get the first date in a selection of a range of dates

    Charles Penprase

      Hi Guys

       

      I'm trying to get the first date in a date selection. The selection can be from one to any number of dates.

       

      Mid(Getfieldselections ( OrderOpenDate,',' ),3,10) works fine for the first 6 selections, after that I get '7 of 173' instead of the dates.

       

      Is there any way I can get a list or a range back from the GetFieldsSelection.

       

      All I have managed to get back are:

       

       

      The first 2 work fine but the 3rd result wont work for me.

       

      Thanks.