<div>
Thanks that seems to work. &nbsp;I agree with your statements but this is a deployed system and those changes are not allowed since it has been sunsetted. &nbsp;I have seen other reports with the times displaying like your example shows. &nbsp;Reports are still allowed.
</div>


Thanks that seems to work.  I agree with your statements but this is a deployed system and those changes are not allowed since it has been sunsetted.  I have seen other reports with the times displaying like your example shows.  Reports are still allowed.

<div>
<div class="content wysiwyg-content">
I need to calculate a start and end time between a date range. &nbsp; This gives the date range and the different times. &nbsp;I need Patient.AnesStartTime and Patient.EndStartTime calculated to show how much time for each patient between the date range.<br />
<br />
SELECT &nbsp; &nbsp; AnesStaff.AnesLastName, AnesStaff.AnesFirstName, Service.Service, Service.MEPERSCode, AnesStaff.FlagRelief, Patient.DateSurgery, Patient.AnesStartTime, <br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Patient.AnesEndTime<br />
FROM &nbsp; &nbsp; &nbsp; &nbsp; Service INNER JOIN<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; AnesStaff ON Service.PatientID = AnesStaff.PatientID INNER JOIN<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Patient ON Service.PatientID = Patient.PatientID AND AnesStaff.PatientID = Patient.PatientID<br />
WHERE &nbsp; &nbsp; (Patient.DateSurgery BETWEEN CONVERT(DATETIME, '2008-03-01 00:00:00', 102) AND CONVERT(DATETIME, '2008-04-01 00:00:00', 102))<br />
<br />
Thanks<a href="https://filedb.experts-exchange.com/incoming/2018/05_w20/1316142/Capture.JPG" target="_blank" title="Screenshot (31 KB)"><img alt="Screenshot" class="file-block lazyload" style="max-width: 800px;" data-src="https://filedb.experts-exchange.com/incoming/2018/05_w20/800_1316142/Capture.JPG" /></a>
</div>
</div>


Capture.JPG

I need to calculate a start and end time between a date range.   This gives the date range and the different times.  I need Patient.AnesStartTime and Patient.EndStartTime calculated to show how much time for each patient between the date range.

SELECT     AnesStaff.AnesLastName, AnesStaff.AnesFirstName, Service.Service, Service.MEPERSCode, AnesStaff.FlagRelief, Patient.DateSurgery, Patient.AnesStartTime, 
                      Patient.AnesEndTime
FROM         Service INNER JOIN
                      AnesStaff ON Service.PatientID = AnesStaff.PatientID INNER JOIN
                      Patient ON Service.PatientID = Patient.PatientID AND AnesStaff.PatientID = Patient.PatientID
WHERE     (Patient.DateSurgery BETWEEN CONVERT(DATETIME, '2008-03-01 00:00:00', 102) AND CONVERT(DATETIME, '2008-04-01 00:00:00', 102))

Thanks

SQL calaulate start time and end time between a date range

SQL Server Reporting Services (SSRS) is a server-based report generation software system from Microsoft. It can prepare and deliver a variety of interactive and printed reports and is administered via a web interface or its web service. Its web services interface also supports the development of custom reporting applications. Finally, SSRS can also be integrated with SharePoint. SSRS competes with other business intelligence tools, most prominently Crystal Reports.

SSRS

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.