I am new to sql2005
My problem is,
I send a date parameter (@fdt and @Tdt) like "DD/MM/YYYY" format through Sql reporting services
My query is select * from deposits where Depdate >= @fdt and Depdate <= @tdt
in the aove query there is no record has been fetched
But i give like this, Inthis case i get a resultselect * from deposits where Depdate >= '2010/04/01' and Depdate <= '2010/08/31'
pls tell me how can i convert the date to "yyyy/mm/dd" in where condition
View Complete Post