Hi, I have two indices which have different formats for creation date (one is YYYY-MM-DDThh:mm:ss and the other is seconds since epoch). When I sort in descending order using the two fields, the returned documents are always from the first index followed by documents from the second index even though the second index may contain documents newer than the first index.
What I want is for Elasticsearch to look at both datetime formats the same way and therefore the results will be merged. Is it possible to do that? Thanks!