# Array with all dates in between **URL:** \ **Category:** Ask for Help\ **Created:** [February 4, 2023, 9:29pm UTC](https://community.glideapps.com/t/array-with-all-dates-in-between/57508 "2023-02-04T21:29:54Z")\ **Posts on this page:** 1\ **Showing post:** 4
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [February 4, 2023, 10:42pm UTC](https://community.glideapps.com/t/array-with-all-dates-in-between/57508/4 "2023-02-04T22:42:05Z")
This is something I want to try but haven’t yet. Currently I do a much more complicated process with VLOOKUPS in a google sheet to get a value that I can use to to build relations. > [@Conditional relations that aren't related to the logged in user](https://community.glideapps.com/t/conditional-relations-that-arent-related-to-the-logged-in-user/57173/5): > > Hi! Some no code solution: In the user Value table you need to prepare Json Object using “Make Json Object” Lookup this column to Project table Finish JSON and prepare template for JQ (select if User value \> Project Value) Transform JSON This filters values from Json by JQ rules JQ there is: map - invoke filter foo for each input select(value) input unchanged if value returns true Try to use [jq play](https://jqplay.org/#) to play with Clear results There n… What you need is probably something a lot simpler. If you can set a start date value somewhere, then you can bring it into a table with a single value column. Then you can add a math column to add 7 days. Then you can use that single value column and math column in an IF column to compare to the date in each row. If it fits within the range, then return a value such as ‘true’. You can use that IF column value to set a filter on your list. --- _[View the full topic](https://community.glideapps.com/t/array-with-all-dates-in-between/57508)._