2 Replies Latest reply on Jan 22, 2013 1:45 PM by Allan Walker

    Date range parameters, filters and calculated fields

    Allan Walker

      Hi all,

       

      I'd like to create a date range parameter, filter and calculated field with these permutations:

       

      1. All incidents
      2. Last 60 days (from today)
      3. Last 120 days (from today)
      4. Report # 1 - SEP. 16, 2012 TO NOV. 19, 2012
      5. Report # 2 - NOV 17, 2012 TO JAN 17 2013

       

      Workbook attached.  Field name is Date of Occurrence. It would be helpful if the parameter was integer as per the list.

       

      Best Regards,

      Allan