How to represent date as multifiled to keep actual date and do full text search.
My mapping
"createdOn":{
"type":"date",
"fields":{
"str": {
"type": "string"
}
}
}
actual dates is stored as is for sorting, range , between etc, and string representation of it for full text search,In my case mostly users may search by month, day, year, my idea is to represent date as string for example 03/29/2017 as march 29 2017, this way I can do match on createdOn.str for 9 or 2017 etc.
This might solve my requirement but I am not sure if this is industry standard, please advice what is the approach to do full text search on date field.