6 Replies Latest reply: Feb 17, 2014 6:21 AM by mayilvahanan ramasamy RSS

    Filter a table object with a calendar

      Hi,

       

      I have a table which displays datas from my database

      example :

      NbName1Name2Date1Date2
      1A1B101/01/201410:00:00
      2B1C101/03/201410:00:00
      3C1D102/01/201410:00:00
      4D1Ed02/17/201410:00:00

       

      Now I have a field CalDate which is a calendar (several dates) created in Script.

      I have added a slider/calendar field on my sheet to display CalDate and I want that on selection of a date, my table only displays datas where Date1 >= CalDate - 7 (and Date 1 <= CalDate)

       

      As it's not a chart, I cannot use something like :

      = (sum({$ <[Date 1]={">=$(=Date(CalDate - 7))"}>} Target ))

       

      So how can I do it ?

      Thanks in advance for your reply