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

(3) Share

Report

Posted on by J_Lee

270

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

All responses (8)

Answers (1)

Verified answer

Waed Ayyad 6,695 Super User 2024 Season 2 on at

Like (0)

Report

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

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
Layan Jwei 7,340 Super User 2024 Season 2 on at

Like (0)

Report

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

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?
J_Lee 270 on at

Like (1)

Report

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

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

Martin Dráb 230,569 Most Valuable Professional on at

Like (0)

Report

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

You can use .. operator to define an interval (e.g. 12/29/2024..1/10/2025).
Layan Jwei 7,340 Super User 2024 Season 2 on at

Like (0)

Report

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

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.
J_Lee 270 on at

Like (0)

Report

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

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

however, i fail to input date range. Please help
Mohamed Amine Mahmoudi 11,560 Super User 2024 Season 2 on at

Like (0)

Report

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

Hi @J_Lee,

Can you please share with us more details ?

Best regards,

Mohamed Amine MAHMOUDI
Martin Dráb 230,569 Most Valuable Professional on at

Like (0)

Report

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

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