Select data between dates?

Question

Is it possible to select data which is between two dates?

Answer 1

yes..
select *
from table1
where date between '5/1/18' and '5/16/18'