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

(2) Share

Report

Posted on by Community member

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!

All responses (4)

Answers (3)

Layan Jwei 7,264 Super User 2024 Season 2 on at

Like (0)

Report

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

Hi Community member,

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

Hana Xue Microsoft Employee on at

Like (0)

Report

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

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

Layan Jwei 7,264 Super User 2024 Season 2 on at

Like (0)

Report

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

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

Mohamed Amine Mahmoudi 10,169 Super User 2024 Season 2 on at

Like (0)

Report

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

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