How get entries between mutiple dates, ordered by date?
Perhaps you could use the Preparse Field plugin, so that you only need to deal with one field. That would make the query easier.
https://plugins.craftcms.com/preparse-field