Extracting hour from date field (scripted field)

[Nuno_Boavida]

Hello Mahdy, for the record, i managed to accomplish that using the following expression

Integer.parseInt(new SimpleDateFormat("HH").format(new Date(doc["created_on"].value)))

Regards