Please advise how to input the particular date range in the query

(4) Share

Report

Posted on by J_Lee

1,326

Please advise how to input the particular date period in filter query for extracting database log.

for example, 28-NOV-2024 to 10-DEC-2024

Categories:

Dynamics 365 Finance

I have the same question (0)

All responses (8)

Answers (1)

Sort by

Martin Dráb 239,451 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Do you want to do it in a form or in code? Do you know how to filter by a single date?

Was this reply helpful? Yes No
Mohamed Amine Mahmoudi 26,803 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @J_Lee,

Can you please share with us more details ?

Best regards,

Mohamed Amine MAHMOUDI

Was this reply helpful? Yes No
J_Lee 1,326 on at

Like (0)

Report
Copy link

Link copied!

I want to extract database log from 28-NOV-2024 to 10-DEC-2024.

however, i fail to input date range. Please help

Was this reply helpful? Yes No
Layan Jwei 8,165 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi,

Check out those links

https://learn.microsoft.com/en-us/dynamics365/fin-ops-core/fin-ops/get-started/advanced-filtering-query-options#advanced-date-queries-that-use-sysqueryrangeutil-methods

https://learn.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/user-interface/filtering#filter-expressions

Thanks,
Layan Jweihan
Please mark this answer as "Verified" if it solved your issue. In order to help others who will face a similar issue in the future.

Was this reply helpful? Yes No
Suggested answer

Martin Dráb 239,451 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

You can use .. operator to define an interval (e.g. 12/29/2024..1/10/2025).

Was this reply helpful? Yes No
J_Lee 1,326 on at

Like (1)

Report
Copy link

Link copied!

i have tried to input the date range as below. System prompt error when execution

Was this reply helpful? Yes No
Layan Jwei 8,165 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi J,

I just tried it in DMF and it worked fine.

can you provide us with the path for the form you opened to reach the query filter?

Was this reply helpful? Yes No
Verified answer

Waed Ayyad 9,135 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi,

You can add: 11/28/2024..12/10/2024 in the filter range without specifying the time I tried it, and it worked. It will return all the data in the range 11/28/2024 12:00:00 am to 12/10/2024 11:59:59 pm.

Thanks,

Waed Ayyad

If this helped, please mark it as "Verified" for others facing the same issue

Was this reply helpful? Yes No