cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
unklealecks Frequent Visitor
Frequent 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 1
Super User
Super User

Re: Overlapping Timesheets

Hi,

 

Share a dataset and show the expected result.