Date time format is incompatible with elasticsearch/opensearch date format.

[fulmicoton]

We introduced the support of date time format in range queries, unfortunately the date time format we support is not that of elastic.

Elasticsearch expect a yyyymmdd format while quickwit expected strptime (%Y-%M-%d)
For instance the following pattern is correct for elasticsearch
yyyy|MM|dd 'T'HH:mm:ss.SSSSSS'Z'

but incorrect for quickwit's range filter as illustrated by #5227

related story: #5109

[kuzaxak]

Implemented in #5462