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 AX (Archived)
Suggested Answer

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

(1) ShareShare
ReportReport
Posted on by

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
    300,894 Super User 2025 Season 2 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

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 AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#1
Priya_K Profile Picture

Priya_K 4

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans