Forum Discussion
unklealecks
8 years agoFrequent Visitor
Overlapping Timesheets
Hello,
I have a table of timesheets with the following columns:
- ID
- ClientID
- ProviderID
- Date of Service (Date)
- TimeWorkedFrom (DateTime)
- TimeWorkedTo (DateTime)
I want to determine if a timesheet has a corresponding overlapping timesheet with the same Date of Service and ClientID.
Any help would be great!
Alex
1 Reply
- Ashish_MathurSuper User
Hi,
Share a dataset and show the expected result.