Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
Capturing days difference between last activity date and current date for an account RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi,

    Need to run a report/Views to capture the last activity date and the days difference between current date and last activity date for an account entity in CRM 2011.

    Thanks & Regards,

    DynCRM

    Tuesday, July 23, 2013 8:28 AM

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi,

    Try this link http://msdn.microsoft.com/en-us/library/ms189794.aspx

    Hope this helps.

    • Proposed as answer by Roshan Mehta Tuesday, July 23, 2013 10:30 AM
    Tuesday, July 23, 2013 10:30 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    You can try using following code in you SSRS report:-

    =IIf(DATEDIFF("s",ReportItems!new_dateofverification.Value,GETDATE()) > 432000, "KPI NOT  MET","KPI MET")

    Regards Faisal

    Tuesday, July 23, 2013 10:41 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Thanks RoscoNZ for your quick response..Since I am a functional person, so is there any other way to achieve without help of SSRS.

    Thanks & Regards,

    DynCRM

    Tuesday, July 23, 2013 11:32 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi,

    Thanks form your reply. Can it be achieved without any code as I am a functional consultant.

    Thanks & Regards,

    DynCRM

    Tuesday, July 23, 2013 11:34 AM
  • Question
    Sign in to vote
    0
    Sign in to vote
    You can create reports in report manager of CRM and it has some functionality of doing sum, average etc. You cannot add a calculated column into your report. Therefore you are left with one option which is ssrs report.

    Regards Faisal

    Tuesday, July 23, 2013 12:11 PM
  • Question
    Sign in to vote
    0
    Sign in to vote
    You could try exporting the data into Excel and then create a formula to display the data you need.
    • Proposed as answer by Roshan Mehta Wednesday, July 24, 2013 10:11 AM
    Wednesday, July 24, 2013 10:11 AM