Model Driven App - Filter View column to earlier than today

[Spikyface]

Within a model driven app, is it possible to filter a view on a custom entity so that it filters records which have a date earlier than today (and dynamically works out what date it is at runtime)?

I had a look for the option but can't see it, it only allows me to use a fixed date

[v-siky-msft · Accepted solution]

Hi @Spikyface ,

Your requirement can be implemented by Out-Of-Box Older Than X Days criterion.

By using the following two filter conditions on any entity’s date field will provide the list of all records Older Than Today:

We need the additional Yesterday filter because the Older Than X Days operator only accepts a value from 1 to 500 and doesn’t support 0.

Hope this helps.

Sik

[Spikyface]

@v-siky-msft that's great, thanks for your help!