How to create a custom view showing older than X days (MS Dynamics) RRS feed

  • Question

  • I want to be able to see view that shows records 'older than X days'. There is an option for Older than X months but I need days. How do I solve this?

    1. I was thinking going through another field to calculate the dates. but the problem is, at the same time, it also calculate the time. e.g. 29/05/2013 4pm -- 31/05/2013 8am (less than 24 hrs), which is still recognized the duration is 0 day. But i want it to be calculated as 1 day.

    so How do i select the date without considering the time issue.

    2. if import the solution, what should i do?

    Thanks in advance.

    Friday, May 31, 2013 7:37 AM


  • Hi,

    A workaround is to create your view with all its conditions and put a condition with older than x months. Then, export the view's Fetch XML, and replace the month with day. Use the exported XML file to build a report in Visual Studio, and then import the report in CRM to use it.

    My Weblog | My Website

    Tuesday, June 4, 2013 1:43 PM