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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics 365 | Integration, Dataverse... / filter on last 30 minutes
Microsoft Dynamics 365 | Integration, Dataverse...
Suggested Answer

filter on last 30 minutes

(0) ShareShare
ReportReport
Posted on by Laura.v.r 55

I need to be able to filter all sales order created longer then 30 min ago.

On the created date time I can use the filter: (lessThanUtcNow()) but don't know how to combine it with "30 min".

Off course I want this flexible :) I don't want to put in the filter before 12/12/2022 14:13 for example.

Every time I open the screen he should see what is 30 min ago and filter.

I have the same question (0)
  • Suggested answer
    a33ik Profile Picture
    a33ik 84,331 Most Valuable Professional on at

    Hello,

    Did you try that:

    pastedimage1670877571847v1.png

  • Laura.v.r Profile Picture
    Laura.v.r 55 on at

    It’s in D365F&O.

    is this the wrong forum?

  • a33ik Profile Picture
    a33ik 84,331 Most Valuable Professional on at

    Ok. That answer is valid for CRM. It's the right forum but to avoid misunderstanding it would be convenient to add a tag or something that will give a clue that this question is related to F&O.

  • Suggested answer
    Haig Liu Profile Picture
    Haig Liu Microsoft Employee on at

    Hi Laura.v.r,

    "LessThanUtcNow()" can only be used according to the specific time. The minimum granularity of other query syntax is days.

    Perhaps you can try LessThanDate(1) or use LessThanUtcNow() with GreaterThanUtcNow().

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…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

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

#1
Martin Dráb Profile Picture

Martin Dráb 49 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 38 Super User 2025 Season 2

#3
#ManoVerse Profile Picture

#ManoVerse 31

Last 30 days Overall leaderboard

Featured topics

Identifying an Org as CDS or Dynamics
Get batch job history log from D365 FO to Power Automate
Gross and Net Weight of Shipments feeding back into Sales Order (from External Source)

Product updates

Dynamics 365 release plans