> For the complete documentation index, see [llms.txt](https://docs.bdb.ai/bdb-documentation/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.bdb.ai/bdb-documentation/data-visualization/self-service/applying-filters/view-specific-filter/date-based-view-filter.md).

# Date-based View Filter

{% hint style="success" %}
Check out the walk-through on how to filter a View based on Date values.
{% endhint %}

![Date-based filter applied to a View](/files/g0sjT43DFYNZiXXnLsZ5)

The users can apply Date based View Filter by selecting the Date Values from the Data Store.&#x20;

The user can provide two kinds of conditions on the Date values: 1. Between, and 2. Relative

### **Between**

* Click the ***Filter*** icon on the ***Design*** page.
* The Filter panel opens, displaying all the available filter values.
* Select a dimension or measure containing ***Date*** values to filter the view.
* Choose the ***Between*** option from the drop-down menu.
* Provide the ***From*** and ***To*** dates.
* Click the ***Apply*** icon. &#x20;

![Applying Date-based View Filter](/files/Q0Z4jEKnp5G27A93ngDN)

* The ***View Filter icon*** gets highlighted.
* The selected view gets filtered as per the applied filter conditions.

![The View gets modified based on the applied Date filter](/files/z76Yk0ZtCVmAYpIOklyw)

### **Relative**

* Click the ***Filter*** icon on the ***Design*** page.
* The ***Filter*** panel opens.
* Select a ***Date*** value as the ***filter condition***.
* Choose the ***Relative*** option from the drop-down.
* Insert a period by selecting the required values.
  * The user gets the ***Last*** and ***This*** under the drop-down menu to select the ***past*** or ***present time zone***.
  * There are ***4 categories of time pointers*** provided in another drop-down menu, which allow the user ***to select a value out of Years/ Months/Weeks/Days***. E.g., the below-given image displays the ***Last 5 years*** as the selected time condition.
* Click the ***Apply*** icon. &#x20;

![Applying the Date-based View filter value](/files/tGVonRBNVp6dGIg0GqPw)

* The ***View Filter*** icon gets highlighted.
* The selected view gets filtered based on the applied conditions.     &#x20;

![](/files/0pQ55tLkR3jJjS02ET6z)

{% hint style="info" %} <mark style="color:green;">Please Note:</mark> The same set of steps can be used to apply the ***Global filter*** based on the date values.
{% endhint %}
