Hi , i want in sql server table between date is not work if it is front end of the windows application date not suport to generate report plz give a valueble solution for that convert(varchar(24),p.Transactiondate,113) between '2016-07-01' and '2016-07-15'

Hi Thanks for writing below links helpful for you....... http://stackoverflow.com/questions/13178752/current-date-without-time http://blog.sqlauthority.com/2007/06/10/sql-server-retrieve-select-only-date-part-from-datetime-best-practice/

Answer