Truncate part of an existing field value to a new field using painless?

[cjcenizal]

You could also try splitting the date value on ", " and using the first element in the resulting array.

CJ