How to apply 'greater than today's date' filter on AOT View.

(4) Share

Report

Posted on by CU03030620-0

Hi Techies,

We are working on one data export requirement, a new data entity is created with view as a datasource, while exporting data from the entity we want to apply a filter on View/datasource where ToDate is greater than today's date or null.

Things we tried are -

Applied range in data source of view as below.

>= getdate()

>= t

The same view we are using in SQL as well. If anyone has worked on similar requirement please guide on this.

Any response is appreciated.

Thanks in advance!

I have the same question (0)

All responses (6)

Answers (3)

Verified answer

Mohamed Amine Mahmoudi 26,416 Super User 2025 Season 2 on at

Like (0)

Report

Hi,

try use this method in the range value "GreaterThanUtcNow ()"

Please refer to this : https://learn.microsoft.com/en-us/dynamics365/fin-ops-core/fin-ops/get-started/advanced-filtering-query-options

Best regards,

Mohamed Amine MAHMOUDI

Was this reply helpful? Yes No
Verified answer

Layan Jwei 8,112 Super User 2025 Season 2 on at

Like (0)

Report

Hi,

As Mohamed said, you can use greaterThanUtcNow()

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
Verified answer

Hana Xue Microsoft Employee on at

Like (0)

Report

Hi,
This issue has been discussed before on the forum and as mentioned below you can use greaterThanUtcNow() or you can simply take a look at the old thread. https://www.dynamicsuser.net/t/how-to-filter-greater-than-today-datetime-reocrds-in-aot-query/63713

Best Regards,
Hana

Was this reply helpful? Yes No
Layan Jwei 8,112 Super User 2025 Season 2 on at

Like (0)

Report

Hi Community member,

Is your question answered? If yes, then please verify the answers that helped

Was this reply helpful? Yes No
Suggested answer

T徐-03070231-0 2 on at

Like (0)

Report

how can I get the sessiondate in the view

Was this reply helpful? Yes No
Martin Dráb 237,948 Most Valuable Professional on at

Like (0)

Report

@T徐-03070231-0 your question doesn't belong here, because the thread is about a different topic. Please create a new thread and explain your problem in detail threre.

Was this reply helpful? Yes No