# Date picker in filters

### **Why time slices?**

With our custom time slice picker, you can visualize data for different time slices (e.g., calculate percentage change or absolute change). These time slices can either be 3 weeks over 3 weeks change or last 3 weeks compared to the same 3 weeks last year. Support for such custom time ranges allows users to define their own **Time Period** and compare the data for different time frames as required. Also, scroll down to know how to customize the calendar view.

### **Where to find the time slices?**

Time slices can be created for any date range filter under **Explore** and **Discover** tabs.

In **Release 4.0**, the date picker has been dramatically redesigned to enhance the user experience.

### **Date picker under Explore tab**

When you filter using a date-based column, the following window appears:

<figure><img src="https://files.helpdocs.io/6dnnwn52e3/articles/xbz0fuobfq/1666612016179/7-hkn-g-ce-6-oh-rls-43-ka-alxu-2-k-7-x-55-tf-xq-b-mwbhq-6-c-cse-iguo-vagglsj-xbw-eqbwc-lqj-dagapc-81-u-x-1-b-uq-p-57-bol-ohqquw-40-lod-4-qo-0-jj-lgg-54-pz-eec-2-r-rvr-zb-voq-wjnng-wdl-36-peav-yz-1-s-3-f-5-e-ttb-2-cwe-qyatdno-i-7-wmz-xkjj-q-3-gbh-deu-rlmfmu-a" alt="Redesigned date picker/time slicer" width="563"><figcaption><p>Date picker window</p></figcaption></figure>

1. The left pane **Pick Time Period** displays a list of pre-defined date ranges. Select the required date range.&#x20;
2. The **Time Period** displays the exact ‘From’ and ‘To’ dates in MM/DD/YYYY format.
3. The corresponding range will be highlighted accordingly and displayed on the calendar.

{% hint style="info" %}
If you select any of the preset date ranges from **Pick Time Period**, you won’t be able to manually interact with the calendar or apply changes to the **Time Period** fields.
{% endhint %}

4. If you select **Custom Date Range** in the left pane, you can manually change the **Time Period** fields. Alternatively, you can interact with the calendar to select the required dates, and the **Time Period** fields will be updated accordingly.

<figure><img src="https://files.helpdocs.io/6dnnwn52e3/articles/xbz0fuobfq/1666612234265/g-9-k-m-2-qo-5-nw-x-5-lcf-vugv-x-5-bljoez-y-7-ejrkr-suj-dm-1-w-6-i-zdpc-m-4-n-vja-nokyea-zryy-90-a-1-zuoi-ny-k-8-dec-d-gr-cf-8-ct-bot-igkhd-dw-wq-wm-bo-3-x-6-m-vg-5-v-3-s-ux-84-gpg-tqp-y-1-t-7-a-04-ek-kp-tc-v-21-u-gcoxhiu-hi-re-vc-8-hh-aae-3-g-fs-gkuu-dgf-tbuwwmx-ozww" alt="Custom date range picker" width="563"><figcaption><p>Custom date range</p></figcaption></figure>

5. **Custom Time Slicer** allows you to create a custom time period instead of date ranges.
6. Select **Custom Time Slicer** in the left pane; you can find another row of fields added under **Time Period**.
7. Click on each field to view the corresponding dropdown list, where you can select the required time slice. The dates on the calendar will be highlighted accordingly.
8. Using **Custom Time Slicer**, you can select *previous/next ‘n’ number of days/weeks/months/quarters/years* that exist in *this/last/last to last year*.

<figure><img src="https://files.helpdocs.io/6dnnwn52e3/articles/xbz0fuobfq/1666613600769/zsckhx-7-avm-fwt-4-zn-02-ik-4-enz-cvk-4-uw-nrj-dq-rqq-4-s-z-oiu-0-ohtqf-96-j-d-76-fb-sg-1-sb-95-zxk-1-e-0-6-kn-rx-5-h-iu-pkd-r-obmu-v-w-2-v-f-1-v-0-gprzo-cw-xv-9-yu-fmn-w-2-nla-8-qj-6-ymam-2-fc-6-iwum-traqjl-xq-pkwxb-q-54-n-yftrg-j-4-uut-d-te-9-a-xnm-uc-rjuq-ea" alt="Custom time slicer" width="563"><figcaption><p>Custom time slicer</p></figcaption></figure>

9. Below the calendar, you can find the following details:

* **Available dates:** The available date range according to the selected Business View.
* **Last refresh:** The date on which the dataset from the Business View was last refreshed.
* **Current date:** The current system date.

<figure><img src="https://977923713-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FJHwf1QFuv1BRPzfSnL2Z%2Fuploads%2FWYWdG40YyM3lqJxd5R3j%2Fdate-picker.gif?alt=media&#x26;token=45f69bd3-1570-45e0-9cd1-1ddd1f9958be" alt="" width="563"><figcaption><p>Date picker window in action</p></figcaption></figure>
