5 Replies Latest reply on Oct 23, 2018 6:48 AM by seraj alam

    How to Calculate No of Days between Start Date and end date Parameters

    Subhashini Gadesina

      Hi

       

      I Have created start date and end date Parameters. I need to Calculate no of Days between start date and end date, If I have selected Start date: 10/1/2018 and end date: 10/23/2018. Here we have 23 days. to get this value which calculation i need to use, by using calculation I need to calculate Average sales per day. Suppose if its 23 days i need to get average calculation based on this 23 days. if its 30 days based on that 30 days I want to show average daily sales.

      I used Datediff('day', start Date, End Date) to get the no of days between start date and end date, but this is not working out.

       

      Please suggest