Type date not working

[floow (Axel)]

Hello,

for the last three days I have been trying to get my Kibana to recognize dates, but with no luck. I am importing the data via python looking like this:

b’\n{"index": {"_index": "index-test"}} \n{"Type" : "_doc","Name": "Daivd" ,"Country": "UK" ,”Date": "2020-05-18 00:00:00" } \n'

my mapping looks like this:

PUT index-test
{
  "mappings": {
    "_doc": {
      "properties": {
        "Name": {"type": "string","ignore_malformed": true},
        "Country": {"type": "string","ignore_malformed": true},
        "Date": {"type": "date", "format":"yyyy-MM-dd HH:mm:ss"}
      }
    }
  }
}

However after uploading the data the date is always recognized as a string, not a date. Do you have any idea on how I can change my mapping or my upload string in order for the date to get recognized as a date.

Regards