# Backward Date

**URL:** <https://community.amazonquick.com/t/backward-date/47291>\
**Category:** Q&A\
**Tags:** feature-request, date, filters, Business-Intelligence-Engineer, quick-sight\
**Created:** [June 16, 2025, 2:41am UTC](https://community.amazonquick.com/t/backward-date/47291 "2025-06-16T02:41:27Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![suvarna0212](https://avatars.discourse-cdn.com/v4/letter/s/ce73a5/32.png) [@suvarna0212](https://community.amazonquick.com/u/suvarna0212)\
**Post date:** [June 16, 2025, 2:41am UTC](https://community.amazonquick.com/t/backward-date/47291/1 "2025-06-16T02:41:27Z")

</div>

hi, i am trying to use filter control over a column of birthdate.. but i cant select dates older than 20 years… as current years is 2025.. i can max see year till 2005. Please help on the same.

---

<div class="post-metadata">

**Author:** ![suvarna0212](https://avatars.discourse-cdn.com/v4/letter/s/ce73a5/32.png) [@suvarna0212](https://community.amazonquick.com/u/suvarna0212)\
**Post date:** [June 16, 2025, 2:53am UTC](https://community.amazonquick.com/t/backward-date/47291/2 "2025-06-16T02:53:13Z")

</div>

i need select specific date like.. 5 sept 1993..can show last N years but not specific dates

---

<div class="post-metadata">

**Author:** ![Giridhar.Prabhu](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/giridhar.prabhu/32/27789_2.png) [@Giridhar.Prabhu](https://community.amazonquick.com/u/Giridhar.Prabhu)\
**Post date:** [June 16, 2025, 7:21am UTC](https://community.amazonquick.com/t/backward-date/47291/3 "2025-06-16T07:21:20Z")

</div>

Hi @suvarna0212

You are right. The Date filter only shows dates till 2005.

Since date of birth’s can be in random; can you approach this as a text field where the user can enter the date of birth (in a specific format) and you create a calculated field that converts that text to date. You can then create another calculated views that compares your date of bitrh column to this caluated field and return a 1 (True) if there is a match or 0 (False) if there is no match. In your visual you can create a filter on this calculated field for values that equal to 1.

So basically a workaround to get what you want.

Regards,  
Giri

---

<div class="post-metadata">

**Author:** ![cmwade77](https://avatars.discourse-cdn.com/v4/letter/c/c5a1d2/32.png) [@cmwade77](https://community.amazonquick.com/u/cmwade77)\
**Post date:** [June 17, 2025, 4:43pm UTC](https://community.amazonquick.com/t/backward-date/47291/4 "2025-06-17T16:43:43Z")

</div>

Why would the data filter have an arbitrary limit of 20 years? It should allow back to the “beginning of time” or something like 0000. I can actually see applications for this involved with historical documents, Genealogy, etc. What do we need to do to encourage having this fixed?

---

<div class="post-metadata">

**Author:** ![Giridhar.Prabhu](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/giridhar.prabhu/32/27789_2.png) [@Giridhar.Prabhu](https://community.amazonquick.com/u/Giridhar.Prabhu)\
**Post date:** [June 18, 2025, 4:59am UTC](https://community.amazonquick.com/t/backward-date/47291/5 "2025-06-18T04:59:00Z")

</div>

@Brett @WLS-DM

Please can you help mark this as a feature request? The date paramteter only goes back till 2005.

---

<div class="post-metadata">

**Author:** ![Brett](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/brett/32/36494_2.png) [@Brett](https://community.amazonquick.com/u/Brett)\
**Post date:** [June 18, 2025, 3:22pm UTC](https://community.amazonquick.com/t/backward-date/47291/6 "2025-06-18T15:22:23Z")

</div>

No problem, I will mark this as a feature request.