web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Microsoft Dynamics CRM (Archived)

Advanced Search - sliding date range

(0) ShareShare
ReportReport
Posted on by

 Hello all,

I am new to the 365 community and relatively new with MS Dynamics.  I am looking to set up and advanced search query that will provide data for a specific date range.  I was able to do that by selecting "on or after" and "on or before" however this will only provide data for that specific period.  I would like to create a dashboard that reflects the advanced search results but would need the date range to automatically advance a one week period at a time so that I could generate weekly reports with the previous weeks statistics.  Creating a dashboard that only displays one week worth of info is not helpful.

Is there a way to automatically have MSD advance the date range every week with the previous weeks data ?  

*This post is locked for comments

I have the same question (0)
  • David Jennaway Profile Picture
    14,065 on at

    Your best option is normally to use the operators like Next X Days and/or Last X Days, rather than On Or After / Before

  • Community Member Profile Picture
    on at

    Thank you for the advice.  Only issue is that it will keep a running tally of EX: last week, if I run the report say on a Wednesday but need data for the previous Monday through Friday stats, this method would not work.

  • David Jennaway Profile Picture
    14,065 on at

    The LastWeek operator should work for that scenario

  • Community Member Profile Picture
    on at

    That's great, I did not realize that this option would snapshot the Sunday to Saturday calendar week.  This should be what I am looking for.   Thank you very much.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the April Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
ScottDurow Profile Picture

ScottDurow 2

#2
GJones Profile Picture

GJones 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans