Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Advanced Filter criter...
Microsoft Dynamics AX (Archived)
Suggested answer

Advanced Filter criteria to select date/time values more than 10 minutes ago

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

I want to use the advanced filter functionality to set up a batch process that selects all kanbans with an Emptied date/time stamp that was more than 10 minutes ago (I want to give people time to edit the quantity before the batch selects it). I know how to use (DayRange()) to do this with full days, but is there a way to do the same type of filter criteria based on the time part of the date/time field?

Also, is there any good syntax reference anywhere to the list of functions (like DayRange) and other syntax (like SQL statements) that can be used in advanced filters?

Thanks in advance

*This post is locked for comments

  • Suggested answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,820 Super User 2024 Season 2 on at
    RE: Advanced Filter criteria to select date/time values more than 10 minutes ago

    Hi Garys,

    The DayRange() and other syntax can be found in the class SysQueryRangeUtil. The one you are looking for is not available. The syntax greaterThanUtcDate() and lessThanUtcDate() are close to your needs, but also calculates with days. You can create new methods in this class. These are then also available in the advanced filters. Within the new method you can calculate with e.g. minutes in stead of days.

    You need to have development skills to achieve it.

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

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey Pt 2

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,820 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,514 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans