Convert crtime column - epoch to ISO human-readable time

I have a csv time containing a unix crtime column with values like 1528926082 that I want to convert while importing the .csv file. The above would convert to “Wed Jun 13 2018 21:41:22 GMT+0000”.

I’ve tried adding it in as a Text and Keyword type and then modifying the script with
“startTime”: {
“format”: “epoch_millis”,
“type”: “date”

but it produces a JSON error. Thanks for help!

Hi Dave,

In your json script closing braces is missing. Although you can simply do it by selecting the date field type and using this format under the advance mappings:

“format”: “epoch_millis”