Dear All,
I would like to compare a selected Date with a range of dates in sqlserver database.
The date format is dd/mm/yyyy and computer system date is also the same.
but the problem is when i run the query it doesn't return a result but if
the matching date was in the format mm/dd/yyyy the query will return the
date.

the database collation is latin_general.

I need the query to match the date format dd/mm/yyyy

so how can i solve the problem??