1 Reply Latest reply on Mar 20, 2013 9:49 PM by Joshua Milligan

    Would like to create a date dimension based off two other dates and have the table populate based on the original dates

    sarah.sadaragnani

      Hi,

       

      I'm trying to create a custom date based on two dates, i.e. Order Date and Sales Date. The purpose of the date is for grouping and display (in the end I only need to display current month and year to date values). The data would need to populate the table based on Order Date and Sales Dates for the record.

       

      If there is a Quote Date and no Sales Date, only the quote related data should be displayed on the table. If the Order Date is December and the Sales Date is January, then the order is counted in December and the sale in January.

       

      I’ve tried Custom Date and don’t get the correct results.

       

      Any help would be great.