I have table which has date ranges stored
Sdate |
Edate |
1-Jan-2019 |
10-Jan-2019 |
15-Mar-2019 |
20-Mar-2019 |
10-Apr-2019 |
25-Apr-2019 |
3-May-2019 |
2-Jun-2019 |
Now I want check whether 16-May-2019 falls any of these date ranges
According to me it falls last one (3-May-2019 to 2-June-2019)
So as it falls these range I Want return the result 'yes' if not then 'No'