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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
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

(1) ShareShare
ReportReport
Posted on by Community Member

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

I have the same question (0)
  • Suggested answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 303,314 Super User 2026 Season 1 on at

    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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the February Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Sagar Suman Profile Picture

Sagar Suman 2 Super User 2026 Season 1

#1
Alexey Lekanov Profile Picture

Alexey Lekanov 2

#1
Pratik Bhosle Profile Picture

Pratik Bhosle 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans