Microsoft Dynamics 365 | Integration, Dataverse...

How to Filter a Public View in Greater Than or Equal to Current Date

(2) Share

Report

Posted on by MH-07050742-0

We have a public view of a table which we want to filter the column ENDDATE on everything Greater than or Equal to Todays Date. But if one puts in the option "On or after" one can only select a fixed date.

What setting should one do to create a dynamic filter that allways selects everything with an enddate larger than or equal to todsays date?

Categories:

Power Platform integration

I have the same question (0)

All responses (5)

Answers (0)

Adis 6,069 Super User 2025 Season 2 on at

Like (0)

Report

Hi,

Can you try to put in (Day(0))

Advanced filtering and query syntax - Finance & Operations | Dynamics 365 | Microsoft Learn

Kind regards, Adis

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

Keep in mind that it is possible to mark more than one answer as verified

Was this reply helpful? Yes No
MH-07050742-0 10 on at

Like (0)

Report

Thanks for the suggestion Adis.

But I can't see how to put in (Day(0)).

Whenever you choose the option "On or After" the only date-option is to choose a date in the calendar that pops up.

This seems strange to me though. Usually one have the option of entering a "dynamic" date. But I cannot see how.

Best regards,

Mikael Helmers

Was this reply helpful? Yes No
Suggested answer

Tom_Gioielli 2,800 Super User 2025 Season 2 on at

Like (1)

Report
There are probably a few ways to do this, but I prefer the path of least resistance in a situation like this.

Add a new formula or calculdated field to your table. The field should be a boolean (TRUE/FALSE), with a formula like the following (my syntax might be a little off, but you should be able to get it with the prompts):

End Date > Today()

Use this new field in your system views.

End Date in Future = TRUE

The formula fields are always calculated and up to date, so no backfill is necessary. There's also no separate code to deploy or maintain, and this uses all standard functionality in CRM without extension. It should meet your requirement and take less than an hour to do. Hope this approach helps. Good luck!

Was this reply helpful? Yes No
MH-07050742-0 10 on at

Like (1)

Report

Thanks Tom_Gioielli for your answer. We have done exactly that. But I posed the question because I thought that it really should be a simpler way of doing this.

Best regards,

Mikael Helmers

Was this reply helpful? Yes No
Suggested answer

suva2381 57 on at

Like (0)

Report

Hello,

You can ues a calculated field to check if your field is greaer than current date else use

<condition attribute="createdon" operator="next-x-days" value="9999" />

Was this reply helpful? Yes No