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

Notifications

Announcements

No record found.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
SA-08121319-0 Profile Picture

SA-08121319-0 4

#1
Calum MacFarlane Profile Picture

Calum MacFarlane 4

#3
Alex Fun Wei Jie Profile Picture

Alex Fun Wei Jie 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans