Date data type and time for kibana

Not sure to understand what you mean, but if you are referring to update the mapping of an existing index, that's not recommended. Check this doc page.

It's recommended that you create a new index with the proper mappings and then reindex your existing data into the new one.