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


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.bdb.ai/bdb-documentation/data-visualization/self-service/applying-filters/view-specific-filter/date-based-view-filter.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.
