CREATE PROC [dbo].[sp_RemittanceListingByDate]
(
	@DateFrom DATETIME
	,@DateTo DATETIME
)
AS

SELECT	*
FROM	pal_vRemittanceListing R
WHERE	LEFT(CONVERT(VARCHAR(50), R.Date, 120) , 10)  
			BETWEEN LEFT(CONVERT(VARCHAR(50), @DateFrom, 120) , 10) AND LEFT(CONVERT(VARCHAR(50), @DateTo, 120) , 10)
ORDER BY R.Date



