How to get date to format correctly

Hi,

You have to set the mappings of the destination index before the transform ingesting documents. If transform ingest documents before set mappings, field types are determined by Elasticsearch dynamically.