Find records with date range in Model driven app using Advance Find

When you work in Model driven app – especially around date field, you may need to search record based on certain conditions.

Some of the options are shown in below image

The most often used filter criterias are “On”, “On or after” and “On or before”.

If we want to search records based on two date fields such as by using between operator, we need to use Advance search.

Before that, let see how “On or after” and “On or before” filter works. This is required to build our between filteration criteria.

On or after :

Consider the below records and see the published date in these records.

To get records after 1st of Aug 2021, the filteration shows three records

On or before:

To get records on or before 1st of Aug 2021, the filteration shows only one record

If we need to get record between 1st Aug to 7th Aug 2021, we need to use advanced search or using advance filteration.

Advance Search:

Click on the advance search icon on the right hand corner . By using both “On or after” and “One or before”, we can achieve the between date range functionality.

Add the date range as shown below

Result shows records within the selected range of dates.

Advance Filter:

Click on the “Advance filter” option

Select the same filteration that we have discussed above

Records will be filtered out with the date range

Looking for a video demo? I have explained the same in the video below.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s