> 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](https://972575688-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FRYq1HgffNfbnIMWPu1D5%2Fuploads%2FNhVtEPOagQPUiOCKqKl4%2FFilterWithDateColumn.gif?alt=media\&token=851518c5-de77-42a0-af5e-18e404ffb0fb)

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

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.  

![Applying Date-based View Filter](https://972575688-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FRYq1HgffNfbnIMWPu1D5%2Fuploads%2FmxeEPx7PlH6XfJjqBbOw%2Fimage.png?alt=media\&token=39a6c320-dd56-4787-b6d6-0306c30882c3)

* 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](https://972575688-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FRYq1HgffNfbnIMWPu1D5%2Fuploads%2FTSXwTYdeYz4UuHtLPLgZ%2Fimage.png?alt=media\&token=f94f5db5-df0a-465e-98e2-044667d8287e)

### **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.  

![Applying the Date-based View filter value](https://972575688-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FRYq1HgffNfbnIMWPu1D5%2Fuploads%2FmxoUszASkvfcLtYqN5uG%2Fimage.png?alt=media\&token=cc9c7d42-4a72-4aec-bc0b-b0de268e71c9)

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

![](https://972575688-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FRYq1HgffNfbnIMWPu1D5%2Fuploads%2Fcw8AUvAUSGG7ymMiSnDC%2Fimage.png?alt=media\&token=7f54c991-1513-4d6e-83d3-72fab3db4c96)

{% 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 %}