Extract 'Year' from 'new Date()' function in Kibana scripted field

Elastic Stack Kibana
1

How can I extract only year (2020) from new Date() function in Kibana scripted field?
Following is scripted field entry
new Date()
Preview of above function displays
{
"_id": "a38be692-7b1c-4d9b-a8eb-cfedb15e6937",
"Date test": [
"2020-08-10T18:18:40.822Z"
]
},
Appreciate your help.

2

Hello Mike,

You should be able to use new SimpleDateFormat('yyyy') to grab the year. Reference: Scripted fields date parse.

Regards,
Aaron

3

Thanks Aaron. I applied following in scripted field and got current year.
scripted field...
def date = new Date();
def sdf = new SimpleDateFormat('yyyy');
return sdf.format(date);

output ....
[ { "_id": "a38be692-7b1c-4d9b-a8eb-cfedb15e6937", "Date test": [ "2020" ] },

1 Like
4

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.