Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics 365 | Integration, Dataverse...
Answered

Advanced find retrieve data on createdon - 5 days

(0) ShareShare
ReportReport
Posted on by 2,139

Hi!

I want to create a query with advanced find to retrieve dinamycally records on createdon - 5 days.


If i run my query today i want to get all records from 12/06/2020. If i run my query tomorrow i should get records from 13/06/2020 and so on

There is possibly to do this with date filters criterias?

  • Verified answer
    Linn Zaw Win Profile Picture
    3,407 on at
    RE: Advanced find retrieve data on createdon - 5 days

    If you want to query the records created exactly on last 5 days ago, you cannot achieve that in Advanced Find. However, you can achieve that in FetchXML query (sample below) for any other places (JavaScript, C# SDK, Power Automate, SSRS, etc.).

    For more details, check out in the blog post by Jonas Rapp
    https://jonasr.app/2020/06/date-intervals/

      
        
        
          
          
        
        
          
            
          
        
      
    
     

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

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Adis Hodzic – Community Spotlight

We are honored to recognize Adis Hodzic as our May 2025 Community…

Kudos to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Microsoft Dynamics 365 | Integration, Dataverse, and general topics

#1
Siv Sagar Profile Picture

Siv Sagar 149 Super User 2025 Season 1

#2
Daivat Vartak (v-9davar) Profile Picture

Daivat Vartak (v-9d... 53 Super User 2025 Season 1

#3
Vahid Ghafarpour Profile Picture

Vahid Ghafarpour 32 Super User 2025 Season 1

Overall leaderboard

Product updates

Dynamics 365 release plans