I have data in elasticsearch and the date format is like:
when i index this into kibana, it recognizes it as a date, but when i try to visualize anything i get:
failed to parse date field [12/22/2017] with format [yyyy/MM/dd HH:mm:ss || yyyy/MM/dd ||epoch_millis]...........Value 22 for monthofyear must be in the range
when i try any other date format, it comes in as a string and i've also tried scripting :
new SimpleDateFormat('dd/MM/YYYY' HH:mm:ss).parse(doc['Date'].value);
but this doesn't seem to fix it, as a string with newDate column i get an error of
unrecognized characters at the end of [2017/12/22]: [/12/22 00:00:00]" }}}]}, "status":400
Any ideas how to fix this?