4 Replies Latest reply: May 13, 2015 3:33 PM by Frankie Liu RSS

    Can you exclude items from listbox?

    Frankie Liu

      Hi All,

       

      I have a field called [Reporting Date] where it has quarter dates. I want to create 2 listboxes for this [Reporting Date] field where i want to show in First Listbox and Second Listbox:

       

      [Reporting Date]:

       

      3/31/2015

      1/31/2015

      12/31/2014

      9/30/2014

       

       

      First Listbox: just want to show current or most current quarter. With the above quarter dates, it should only show "3/31/2015"

       

      Second Listbox: It's the opposite to the first i want to show all quarters except "3/31/2015"

      1/31/2015

      12/31/2014

      9/30/2014

       

      I have tried "Only()" without any success. Any inputs will be greately apprecaited!

       

      Frankie