I have two date field in a table.
Start and End
I need to run a query to find out which records in a period.
in database have two date fields (event_start and event_end)
I want to find out all activities include in 13/8 to 15/9.
Not use between. Because some event maybe began on 10/9 but end date is over 15/9. So use between can not find out accurately.
How can I do?