Date with long value not working

[umeshmishra099 (Umesh Mishra)]

I have below mapping
{
"indexTest": {
"mappings": {
"indexTest_type": {
"properties": {
"date22": {
"type": "dateColumn",
"format": "yyyy-MM-dd||yyyy-MM-dd'T'HH:mm:ss||yyyy-MM-dd HH:mm:ss||yyyy-MM-dd'T'HH:mm:ss.SSS'Z'||HH:mm:ss||HH:mm:ss.SSS||epoch_millis"
}
}
}
}
}
}

indexed value

"_source": {
"dateColumn": "2017-09-01"
}

I am trying to search based on long value of date i am not getting the response . Please find search query below

GET indexTest/_search
{
"query": {
"match": {
"dateColumn": {
"query": "1504204200000"
}
}
}
}

same is working for dateTime value

[spinscale (Alexander Reelsen)]

can you please provide a fully fledged example for reproduction, which includes index creation, mapping creation, document indexing? You mentioned a dateTime value, but your _source does not include it.

Please take some time to come up with something that is reproducible for others, otherwise it is super hard to help.

Also, as this forum supports markdown, please use it to properly format code snippets - this makes it infinitely more readable, which increases your chances of someone looking at your problem.

Thanks a lot!