Skip to main content
Topics#Reports & DashboardsQuestion de Olivia Forde
Olivia Forde (Lifes2good) a posé une question dans #Reports & Dashboards
26 juil. 2013, 09:10

Can I use a date comparison such as Account Created Date greater than Opportunity Close Date as a report filter

I am running a report to show No of New Customers V Existing Customers each month for the past year and I want to check if they are new by comparing the Opportunity Close Date and the Account Created Date - is this possible ?
5 réponses
  1. Jeff May
    26 juil. 2013, 10:22
    You can create a custom formula field on the Opportunity record which uses Account.CreatedDate and Opportunity.CloseDate.  You could calculate the number of days between the two, or you could return a true/false depending on if the 2 dates are in the same month.

     

    For example:

     

    MONTH(CLoseDate) = MONTH(Account.CreatedDate)

     

    returns true in a checkbox formula field if the dates are in the same month.

     

    Use the dropdowns and picklists to assemble the formula you need from the functions and fields available.
Rédiger une réponse...
0/9000