dd/mm/yyyy

[GM]

i have datacolumn that formating dd/mm/yyyy hh/mm/ss. i try getting between from two date like
select * from X Where Date between 01.11.2008 11/12/33 and 30.11.2008 11/12/33. but it runs wrong.i can not displaY DIFFRENCE DATE