I am working on asp.net project. I have two dates stored in database for a vacancy. Posting date and deadline date. I want that If a user searches for any vacancy with date range then if vacancy's start date or end date falls in that range then it should be selected. Like if user selects date range March 10 to April 10 and vacancy start date is MArch 1 and deadline date is 20 march then it should be shwon. 

dummy sql

```
select *
from vacancies v
where v.start date in date range or
      v. end date in date range

```

What will be sql for it