# Create a date range parameter **URL:** \ **Category:** Q&A\ **Tags:** parameters, feature-request, quick-sight\ **Created:** [September 26, 2022, 5:38pm UTC](https://community.amazonquick.com/t/create-a-date-range-parameter/6293 "2022-09-26T17:38:16Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![cpatrone](https://avatars.discourse-cdn.com/v4/letter/c/59ef9b/32.png) [@cpatrone](https://community.amazonquick.com/u/cpatrone)\ **Post date:** [September 26, 2022, 5:38pm UTC](https://community.amazonquick.com/t/create-a-date-range-parameter/6293/1 "2022-09-26T17:38:16Z")
I would like the ability to create a date range parameter to feed into a calculated field. I do not believe this functionality is currently available, so please treat this as a feature request. My use case: I am creating a report that will compare KPIs from two distinct date ranges. I am working around this right now by displaying 4 date parameters (2 start dates and 2 end dates for the range comparisons). This makes it difficult to make an intuitive UI for the end users to utilize. I would much prefer being able to surface two date range parameters. Screen shot attached of my current controls section. ![chrome_AdHQ3WkiMC](https://d1wl4jav5dp96l.cloudfront.net/original/2X/2/2452f875853bb81b4943d4c9dbf430201ef15ecd.png) ---
**Author:** ![Max](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/max/32/2288_2.png) [@Max](https://community.amazonquick.com/u/Max)\ **Post date:** [September 26, 2022, 7:12pm UTC](https://community.amazonquick.com/t/create-a-date-range-parameter/6293/2 "2022-09-26T19:12:28Z")
Do you need them to be parameters? You can make a filter that filters to dates between those selected and then add that to the sheet. ![image](https://d1wl4jav5dp96l.cloudfront.net/original/2X/0/0a63857f93a1584a7c744b52a3bba9c129da0e53.png) ---
**Author:** ![cpatrone](https://avatars.discourse-cdn.com/v4/letter/c/59ef9b/32.png) [@cpatrone](https://community.amazonquick.com/u/cpatrone)\ **Post date:** [September 26, 2022, 8:09pm UTC](https://community.amazonquick.com/t/create-a-date-range-parameter/6293/3 "2022-09-26T20:09:33Z")
Hey Max, Thanks for the reply. Unfortunately using the range as a filter will not allow for comparison of two distinct date ranges on a single report (as far as I can tell). I’m using the parameter dates in a calculated field in order to aggregate the KPIs for the given range. See my redacted screen shot for an example of how I am using the parameters in the calculated fields. ![chrome_reihs8T6xj](https://d1wl4jav5dp96l.cloudfront.net/original/2X/2/2ca871dc88577c9ba80861c0f851e0315b375d01.png) ---
**Author:** ![Max](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/max/32/2288_2.png) [@Max](https://community.amazonquick.com/u/Max)\ **Post date:** [September 26, 2022, 8:45pm UTC](https://community.amazonquick.com/t/create-a-date-range-parameter/6293/4 "2022-09-26T20:45:52Z")
You can have two range filters. You would just add another filter and do the same process. However, if you are using these dates in a calculated view in any way you would need to use parameters. ---
**Author:** ![Ramon\_Lopez](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/ramon_lopez/32/2738_2.png) [@Ramon\_Lopez](https://community.amazonquick.com/u/Ramon_Lopez)\ **Post date:** [September 29, 2022, 4:57pm UTC](https://community.amazonquick.com/t/create-a-date-range-parameter/6293/5 "2022-09-29T16:57:21Z")
Hi Chris- Indeed you are correct, it would be nicer to use the between filter & apply it to 2 different parameters. Currently this type of multi parameter control does not exist and only way is with two separate control. From a user experience perspective one way to handle would be to bring the controls to the Sheet and apply some design to visualize group them. As a quick and dirty example please see below. ![image](https://d1wl4jav5dp96l.cloudfront.net/original/2X/2/2562530ca979596a54ebf23b629ffc335f59a229.png) Regards, Ramon Lopez ---
**Author:** ![cpatrone](https://avatars.discourse-cdn.com/v4/letter/c/59ef9b/32.png) [@cpatrone](https://community.amazonquick.com/u/cpatrone)\ **Post date:** [September 29, 2022, 5:48pm UTC](https://community.amazonquick.com/t/create-a-date-range-parameter/6293/6 "2022-09-29T17:48:38Z")
Thank you for confirming and the helpful ux tip. I would love to submit a feature request for this functionality to be considered for future development. Can you point in in the proper direction to do so please?