4 Replies Latest reply on Nov 18, 2016 6:27 PM by Sherzodbek Ibragimov

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

    Jeremy Bartz

      Hello. 

       

      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.

       

      Thanks!