News and Announcements icon

Dynamics 365 CommunityForums Finance | Project Operations, Human Resources, ... How to get data from a...

Finance | Project Operations, Human Resources, ...

Suggested answer

How to get data from ax table which has been modified Today

(0) Share

Report

Report

Posted on by Community Member

i want to select only those records from table whose modifieddatetime is today in where condition

modifieddatetime is default field of ax table

All responses Img

All responses (2)

Answers Img

Answers (0)

Suggested answer

Martin Dráb 233,017 Most Valuable Professional on at

Like (0)

Report

RE: How to get data from ax table which has been modified Today

Wouldn't (greaterThanDate(-1)) does the job?
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: How to get data from ax table which has been modified Today

Hi,

Have you tried using the ...range functionalities that are described on the following sites?

docs.microsoft.com/.../gg964746(v=ax.60)

docs.microsoft.com/.../advanced-filtering-and-query-options

Best regards,

Ludwig

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 294,261 Super User 2025 Season 1

#2

Martin Dráb 233,017 Most Valuable Professional

#3

nmaenpaa 101,158 Moderator

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans