# Two dates overlap with another two dates **URL:** \ **Category:** Ask for Help\ **Created:** [April 14, 2023, 7:25am UTC](https://community.glideapps.com/t/two-dates-overlap-with-another-two-dates/60523 "2023-04-14T07:25:22Z")\ **Posts on this page:** 8\ **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:** [April 14, 2023, 7:25am UTC](https://community.glideapps.com/t/two-dates-overlap-with-another-two-dates/60523/1 "2023-04-14T07:25:22Z")
I’ve been doing rental of machine. Got a list of job in one sheet(Job Page): Machine ID , start date and end date in one sheet And i created one row page (landing page) as home to check whether is there any overlapping date for each machine before adding to the Job Page. I created additional column in Job Page Start Date Selection(first row), End Date Selection(first Row), SV of Start Date Selection and SV of End Date Selection. One if then column to list down the overlapping machine with selected date. Lastly, list the Machine that not included in overlapping list. My question is, if i need to do the same thing but in edit page . How can i do that ? because, the row is dynamic, so i cannot have the SV column form “this item”. So that, they cannot change the date or machine in overlapping date. Do you guys get what i mean? ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [April 14, 2023, 2:43pm UTC](https://community.glideapps.com/t/two-dates-overlap-with-another-two-dates/60523/2 "2023-04-14T14:43:27Z")
What about using the same table as an “edit” screen? Say when the user clicks an “Edit” button, you write the Machine ID, start date and end date of the current row to the helper table, show the “custom edit screen” for that table, do the logic on that row, and if the logic is ok then when the user clicks “Save”, you write that info back to the right 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:** [April 17, 2023, 12:06am UTC](https://community.glideapps.com/t/two-dates-overlap-with-another-two-dates/60523/3 "2023-04-17T00:06:30Z")
Let me try first 🤔 🤔 ---
**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:** [April 17, 2023, 12:58am UTC](https://community.glideapps.com/t/two-dates-overlap-with-another-two-dates/60523/4 "2023-04-17T00:58:10Z")
> [@ThinhDinh](#): > > you write the Machine ID, start date and end date of the current row to the helper table For this step, let say , right now i need to edit at row 200, and selection should be made at the first row, its quite impossible to set column from row 200 to 1 right? ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [April 17, 2023, 1:07am UTC](https://community.glideapps.com/t/two-dates-overlap-with-another-two-dates/60523/5 "2023-04-17T01:07:02Z")
Why is the selection made at the first 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:** [April 17, 2023, 1:17am UTC](https://community.glideapps.com/t/two-dates-overlap-with-another-two-dates/60523/6 "2023-04-17T01:17:41Z")
i’m doing something like Start Date Selection , End Date Selection and get Single Value from the selection to check the overlapping date. ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [April 18, 2023, 12:40am UTC](https://community.glideapps.com/t/two-dates-overlap-with-another-two-dates/60523/7 "2023-04-18T00:40:39Z")
But I assume your “helper” table is a different table from the one you’re using store rental records, is that correct? ---
**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:** [April 19, 2023, 1:03am UTC](https://community.glideapps.com/t/two-dates-overlap-with-another-two-dates/60523/8 "2023-04-19T01:03:55Z")
I put in the same table…