Search different sources of data

I want to be able to search two different sources of data, and order the results for by date.

The two different sources expose date fields with different names, and in different formats which I want to search against.

So far I’ve tried using a Squiz Search Page.

Although the settings in the Squiz Search Page allow for searching against multiple sources of data, when selecting ‘Data Source Record Set’, the additional options don’t seem to allow me to target a particular %ds__X% field (i.e. the date field), in the JSON Data Source.

I haven’t experimented with Dynamic Inputs and Record Filters on an Asset Listing yet, as I don’t think they provide a native way of searching date ranges, whereas a Squiz Search Page does.

Is there an alternative?