5 Replies Latest reply on Oct 23, 2018 12:34 PM by Dan Robidoux

    Create a Date Field to show all dates between 2 Parameters.

    Jeremy Bartz



      I have 2 types of data in my report.  Order Dates and Shipped Dates.  I would like to create a field (Calendar Date) that will show all dates between 2 parameters so I can write 2 calculated fields.


      Shipment Sales: Shipped Date = Calendar Date Then Sales

      Orders Received:  Order Date = Calendar Date Then Orders


      I can't use either Shipped Date or Order Date in the report as if I use Shipped Date, I won't get the Order information on days I don't have shipments and vice versa.

      Therefore I would just like to in essence create a field that is all the dates and then use that to calculate the sales and orders.