Extract HH:mm:ss from datetime and compare in script field

I want to extract HH:mm:ss(eg. 29/03/2024 18:01:01) from datetime and check if it's >= '06:00:00' && <='18:00:00'.
Is there any way to achieve this while creating scripted field?

1 Like

Hi Rakesh, Could you help us with more context and information -

  1. From where you trying to extract this information? Parsing from logstash or something else?
  2. Is it from Elasticsearch data? If yes could you please provide sample document? Also giving index mapping will be beneficial.

Thanks