Forum Discussion
Cleaning Date Data
Hey all,
I have been trying to figure out a way to solve this date issue I am running into with my data mess. So an example is we have 2 years worth of calender data. In one day there should not be overlapping time frames.
Example:
| Subject | Start Date | Start Time | End Date | End Time |
| Tentatively available | 7/21/2019 | 9:00 AM | 7/21/2019 | 10:30 AM |
| call sheet | 7/21/2019 | 11:00 AM | 7/21/2019 | 4:00 PM |
| Assesories | 7/21/2019 | 3:00 PM | 7/21/2019 | 5:00 PM |
| Maintanance | 7/21/2019 | 5:00 PM | 7/21/2019 | 5:30 PM |
So this could be an example of one days date data we pull. Now I am going to show a table of what my goal is:
| Subject | Start Date | Start Time | End Date | End Date |
| Tentatively available | 7/21/2019 | 9:00 AM | 7/21/2019 | 10:30 AM |
| call sheet | 7/21/2019 | 11:00 AM | 7/21/2019 | 4:00 PM |
| Assesories | 7/21/2019 | 4:00 PM | 7/21/2019 | 5:00 PM |
| Maintanance | 7/21/2019 | 5:00 PM | 7/21/2019 | 5:30 PM |
So, basically there can not be overlapping time frames for anyday of data. Also, there is a rank for these subjects. Meaning if a call sheet has a time interference with another subject, lets say assesories due to this example, then the call sheet holds the interfered time within its start time and end time.
