4 Replies Latest reply on Dec 21, 2015 4:40 PM by Chandra kanth

    Getting the number of records in report based on user input on date and number of days.

    Chandra kanth

      Hi,

       

      I have requirement where there is dashboard prompt which selects date, second column interval consists of >,<,=  and third column is having number (days)

      for eg user enters: 18/12/2015, <, 9. That is i have report which should get the data (records) of 9 days earlier from the date specified (from 10/12/2015 to 18/12/2015).

      similarly for > and =.

       

      How to achieve this. I am unable to write the script and i am using date column in my report. Request you please advice how to solve this.

      Please see below screen shot for reference.

       

      timediff.jpg

       

      Regards,

      Chandra kanth.