# Show data from - to **URL:** \ **Category:** Ask for Help\ **Created:** [September 12, 2020, 9:04pm UTC](https://community.glideapps.com/t/show-data-from-to/15702 "2020-09-12T21:04:04Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![Alexdz](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/alexdz/32/10382_2.png) [@Alexdz](https://community.glideapps.com/u/Alexdz)\ **Post date:** [September 12, 2020, 9:04pm UTC](https://community.glideapps.com/t/show-data-from-to/15702/1 "2020-09-12T21:04:04Z")
Hello! Is it possible to show data based on date calculations? For example in the filter? For example: - last 30 days - from date x to date y ---
**Author:** ![sardamit](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sardamit/32/263_2.png) [@sardamit](https://community.glideapps.com/u/sardamit)\ **Post date:** [September 12, 2020, 9:37pm UTC](https://community.glideapps.com/t/show-data-from-to/15702/2 "2020-09-12T21:37:18Z")
You can write a nested if else for the first case. For the second, you will have to use some trickery to filter the data based on the selection. I use it in one of my templates: [https://www.loom.com/share/68d769a166f94040ba7caa3d86400bda](https://www.loom.com/share/68d769a166f94040ba7caa3d86400bda) ---
**Author:** ![darder](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darder/32/12788_2.png) [@darder](https://community.glideapps.com/u/darder)\ **Post date:** [September 12, 2020, 10:22pm UTC](https://community.glideapps.com/t/show-data-from-to/15702/3 "2020-09-12T22:22:34Z")
I have created a calculated array I my spreadsheet which shows the date 30 days after now in any single row of an events sheet whit this formula. ={“DateUsa30”;ARRAYFORMULA(IF(E2:E\<\>"";TEXT(Today ()+30;“DD/MM/YYYY”);""))} You can use this formula in the first row in any new column and E2 refers to the column where I have the Date of an event just to avoid to write new rows or Today+30 data if not necessary Try to change data type to date format of you new array column in your Glide Sheet if it doesn’t recognize it as date format. Now you can use before or after filters for any row of your sheet as shown below. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/5/5922472f5086a6e22554c6f91da92033bac9d021.jpeg) Hope it helps. ---
**Author:** ![Sales\_Manager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sales_manager/32/16172_2.png) [@Sales\_Manager](https://community.glideapps.com/u/Sales_Manager)\ **Post date:** [August 29, 2022, 1:37pm UTC](https://community.glideapps.com/t/show-data-from-to/15702/4 "2022-08-29T13:37:42Z")
Is there any other component that can be used other than the chart? ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [August 29, 2022, 1:42pm UTC](https://community.glideapps.com/t/show-data-from-to/15702/5 "2022-08-29T13:42:01Z")
The methods discussed here are quite old and dated. There are much easier ways to do this now. What specifically is your use case? ---
**Author:** ![Sales\_Manager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sales_manager/32/16172_2.png) [@Sales\_Manager](https://community.glideapps.com/u/Sales_Manager)\ **Post date:** [August 29, 2022, 1:50pm UTC](https://community.glideapps.com/t/show-data-from-to/15702/6 "2022-08-29T13:50:27Z")
I have three columns: Date - product name - price. I created a report: component “choice” to select the product, then select the date (from - to) and the report displays the total sale I don’t want to use "charts " Is there another component to display? ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [August 29, 2022, 1:54pm UTC](https://community.glideapps.com/t/show-data-from-to/15702/7 "2022-08-29T13:54:37Z")
No, you don’t have to use a chart. You can use which ever component makes sense. What do you expect the result to look like on the screen? A list? A table? Something else?