Dim queryString1 As String = "SELECT A.ExitID, A.EmpNo, B.Name, A.DeptmtID, CONVERT(varchar, A.ExitTimeFrom, 103) AS ExitTimeFrom, CONVERT(varchar, A.ExitTimeTo, 103) AS ExitTimeTo, A.ExitFrom, A.ExitTo, C.ExitStatus, A.Purpose FROM ExitPassDetails AS A LEFT OUTER JOIN CMOS.dbo.Boss_Employee_Profile AS B ON A.EmpNo = B.EmpNo LEFT OUTER JOIN ExitPassStatus AS C ON A.ExitStatus = C.StatusID WHERE (A.ExitTimeFrom >= DATEPART(m, GETDATE())) ORDER BY ExitTimeFrom DESC"
WHERE (CONVERT(varchar, A.ExitTimeFrom, 103) >= CONVERT(varchar, GETDATE(), 103))
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)