2 Replies Latest reply: Mar 31, 2016 4:03 AM by ashok Velisetty RSS

    List Box for last 7, 14, 30 days?

      Here is what I have written for the listbox expression:



      if(Date(Day)>Date(mDate-7), '7',




      mdate is the maximum date, saved as a variable during the load script.


      The resulting listbox has '7' and '14' as options.

      '7' works as intended.


      However, selecting '14' only selects 7 days, between 14 and 7 days old.

      How do I fix this so '14' selects all 14 days?