You think that Event Date column is Date Time but it is written as Text in Managed properties and you use that property for sorting.
For sorting to work properly you need link Crawled Property ows_q_DATE_EventDate
to one of predefined Date Managed Properties (Date00-Date09
)
Go to Site Settings.
- Under Site Collection Administration click Go to top level site settings
- Click Search Schema
- find Date under Managed Properties and link Crawled Property
ows_q_DATE_EventDate
Run full crawl.
OR
Go to those four lists and:
- under List Setting
- click Advanced Settings
- and then click on Reindex Document Library.
- After that you can run incremental crawl and this column will be picked up.
At the end you sort by that new Managed Property Date00
.
And default Managed Property name of Event Date column isn't EventDate
but EventDateOWSDATE
:)