# How to make a relation between Date Range **URL:** \ **Category:** Ask for Help\ **Created:** [February 15, 2023, 4:07am UTC](https://community.glideapps.com/t/how-to-make-a-relation-between-date-range/57966 "2023-02-15T04:07:27Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![biha](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/biha/32/84110_2.png) [@biha](https://community.glideapps.com/u/biha)\ **Post date:** [February 15, 2023, 4:07am UTC](https://community.glideapps.com/t/how-to-make-a-relation-between-date-range/57966/1 "2023-02-15T04:07:27Z")
It is possible to check the relation based on date range? For example **Sheet 1** i have: Name | Start Date | End Date | User 1 | 2 Feb 2023 | 5 Feb 2023 **Sheet 2** Name | Date User 1 | 1 Feb 2023 | No relation User 2 | 2 Feb 2023 | No relation User 1 | 3 Feb 2023 | Got relation User 1 | 4 Feb 2023 | Got relation It is possible ? ---
**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\ **Post date:** [February 15, 2023, 4:10am UTC](https://community.glideapps.com/t/how-to-make-a-relation-between-date-range/57966/2 "2023-02-15T04:10:06Z")
Absolutely possible šŸ˜‰ ---
**Author:** ![biha](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/biha/32/84110_2.png) [@biha](https://community.glideapps.com/u/biha)\ **Post date:** [February 15, 2023, 4:13am UTC](https://community.glideapps.com/t/how-to-make-a-relation-between-date-range/57966/3 "2023-02-15T04:13:09Z")
Can i know how ---
**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\ **Post date:** [February 15, 2023, 4:18am UTC](https://community.glideapps.com/t/how-to-make-a-relation-between-date-range/57966/4 "2023-02-15T04:18:22Z")
Very complicated but possibleā€¦ First, let me know what the workflow isā€¦ maybe there is an easier way to do itā€¦ How do you enter dates in sheet 2? is sheet 1 fixed or variables? also, will multiple relations be allowed or only single ones? Alsoā€¦ should it be filtered by user name, or will all data be considered? ---
**Author:** ![biha](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/biha/32/84110_2.png) [@biha](https://community.glideapps.com/u/biha)\ **Post date:** [February 15, 2023, 5:02am UTC](https://community.glideapps.com/t/how-to-make-a-relation-between-date-range/57966/5 "2023-02-15T05:02:32Z")
dates in sheet 2 based on Form. relation will be one-to-one. Filtered by Username. ---
**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\ **Post date:** [February 15, 2023, 5:08am UTC](https://community.glideapps.com/t/how-to-make-a-relation-between-date-range/57966/6 "2023-02-15T05:08:30Z")
1. will the user enter the date in the add item form? 2. is the data in sheet 1 fixed, or will it be updated continuously? 3. relation should find the first match and ignore the rest? 4. only match data from User 1 to User 1? the most important question is #2ā€¦ if the data in sheet 1 is staticā€¦ if yesā€¦ then is not hard to do it ---
**Author:** ![biha](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/biha/32/84110_2.png) [@biha](https://community.glideapps.com/u/biha)\ **Post date:** [February 15, 2023, 5:20am UTC](https://community.glideapps.com/t/how-to-make-a-relation-between-date-range/57966/7 "2023-02-15T05:20:30Z")
Question 1 : user will not add the date . the date is set by SET COLUMN from the other sheet. Example : SHEET 3. Question 2 : Updated continuously is can edit or not right ? Basically can update before the status Approved. Sheet 1 is something like leave form. Start date for leave and end date for leave . Thereā€™s additional column that we need to consider which is status. the data from Sheet 1 is static once the Status approved. cannot be changed anymore. Question 3 : We make it unable if ā€œRelationā€ is not empty . So it must one-to-one relation Question 4 : Basically also based on the status but I believe this name-status can make it. ---
**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\ **Post date:** [February 15, 2023, 5:30am UTC](https://community.glideapps.com/t/how-to-make-a-relation-between-date-range/57966/8 "2023-02-15T05:30:27Z")
okā€¦ I might be wrong because I donā€™t know your App, but this is my solution: 1. set the date in row 1 of sheet 1 User Specific Column (use relation for that) 2. copy that date using a single value to all rows 3. add column if-else: a) user is not user1, set 0, b) date equal or greater start dateā€¦ set 1 4. add column if-else equal or less end date ā€¦ set 1. (if the user is not user1, set 0) 5. add a math column to sum these if-else columns 6. add an if-else column if the sum is 2, then row ID 7. add join step 6 columnā€¦ and this is your relation! copy that to the new entry row ---
**Author:** ![biha](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/biha/32/84110_2.png) [@biha](https://community.glideapps.com/u/biha)\ **Post date:** [February 15, 2023, 5:42am UTC](https://community.glideapps.com/t/how-to-make-a-relation-between-date-range/57966/9 "2023-02-15T05:42:51Z")
No 1 is sheet 1 or sheet 2? because in sheet 1 we have 2 dates required . Start date and end date. ---
**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\ **Post date:** [February 15, 2023, 5:43am UTC](https://community.glideapps.com/t/how-to-make-a-relation-between-date-range/57966/10 "2023-02-15T05:43:49Z")
yes, that is why you need to set that date thereā€¦ so you can compare it to these two datesā€¦ later copy the result to a new rowā€¦ or you can use a single value column to copy date there from sheet 2 ---
**Author:** ![biha](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/biha/32/84110_2.png) [@biha](https://community.glideapps.com/u/biha)\ **Post date:** [February 15, 2023, 5:47am UTC](https://community.glideapps.com/t/how-to-make-a-relation-between-date-range/57966/11 "2023-02-15T05:47:57Z")
To set the date at first is referring to the date in sheet2 right ? ---
**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\ **Post date:** [February 15, 2023, 5:48am UTC](https://community.glideapps.com/t/how-to-make-a-relation-between-date-range/57966/12 "2023-02-15T05:48:40Z")
noā€¦ all action is done in sheet 1ā€¦ result will be copied to sheet 2ā€¦ You need to have temporary USC columns for User Name and Dateā€¦ so you can run if-else columns. Use custom actionā€¦ - step 1 sets the user name and date to the first row in sheet 1ā€¦ - step 2 add a new row with the result from sheet 1 (row id, date, and user name) in sheet 2 ---
**Author:** ![biha](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/biha/32/84110_2.png) [@biha](https://community.glideapps.com/u/biha)\ **Post date:** [February 15, 2023, 5:59am UTC](https://community.glideapps.com/t/how-to-make-a-relation-between-date-range/57966/13 "2023-02-15T05:59:22Z")
But the date you mention in Step 1 is any date or must be the date that i need to copy in Sheet 2? I mean what date to put? Because basically Sheet 1 and Sheet 2 is different form. ---
**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\ **Post date:** [February 15, 2023, 6:00am UTC](https://community.glideapps.com/t/how-to-make-a-relation-between-date-range/57966/14 "2023-02-15T06:00:29Z")
the date that you want to check if is related ---
**Author:** ![biha](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/biha/32/84110_2.png) [@biha](https://community.glideapps.com/u/biha)\ **Post date:** [February 15, 2023, 6:01am UTC](https://community.glideapps.com/t/how-to-make-a-relation-between-date-range/57966/15 "2023-02-15T06:01:55Z")
oooooo. one by oneā€¦ I see ---
**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\ **Post date:** [February 15, 2023, 6:05am UTC](https://community.glideapps.com/t/how-to-make-a-relation-between-date-range/57966/16 "2023-02-15T06:05:54Z")
may I ask what you are doing? I think I did a similar system for one of my customers šŸ˜‰ are you doing leaves to calculate salaries? and checking if leaves are in their working schedule? ---
**Author:** ![biha](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/biha/32/84110_2.png) [@biha](https://community.glideapps.com/u/biha)\ **Post date:** [February 15, 2023, 6:13am UTC](https://community.glideapps.com/t/how-to-make-a-relation-between-date-range/57966/17 "2023-02-15T06:13:57Z")
I am making the Timesheet for technician/servicer. let say they have apply the leave and approved (In sheet 1), they cannot add the timesheet (in sheet 2) or we added for them but unable for them to enter details. thats why i need them to relate each other. ---
**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\ **Post date:** [February 15, 2023, 6:17am UTC](https://community.glideapps.com/t/how-to-make-a-relation-between-date-range/57966/18 "2023-02-15T06:17:51Z")
ohhā€¦ then if you find any sum equal to 2 then do not add a record to the timesheetā€¦ you should start from this explanation LOL ---
**Author:** ![biha](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/biha/32/84110_2.png) [@biha](https://community.glideapps.com/u/biha)\ **Post date:** [February 15, 2023, 6:37am UTC](https://community.glideapps.com/t/how-to-make-a-relation-between-date-range/57966/19 "2023-02-15T06:37:54Z")
But @Uzo , they do add form separately , as i understand your Step, it will add row to the sheet 2 based on the result we create in sheet 1 right? ---
**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\ **Post date:** [February 15, 2023, 6:42am UTC](https://community.glideapps.com/t/how-to-make-a-relation-between-date-range/57966/20 "2023-02-15T06:42:32Z")
yesā€¦ when they choose the date for the timesheetā€¦ set that date in sheet 1, so you will know if the date is validā€¦ then you will create a recordā€¦ so you donā€™t need to create relationsā€¦ unless you want to keep invalid timesheet records? [Next page](https://community.glideapps.com/t/how-to-make-a-relation-between-date-range/57966.md?page=2)