Overlapping Timesheets

[unklealecks]

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

[Ashish_Mathur]

Hi,

Share a dataset and show the expected result.