SQL datetime to AM/PM

just set you datefield in
Payroll_tblAttendance.InTime

Finally:

 (SELECT RIGHT(LTRIM(RIGHT(CONVERT(varchar, Payroll_tblAttendance.InTime, 100),8)),8)) InTime,  

Popular posts from this blog

WPF Crystal Report Viewer Using SAP

ASP.NET MVC razor SAP Crystal report