Company retire age is 55; find employee count and list of employee who get retired in next 5 year

[SA2]

Hi there!

I have a subjected case to find out list of employees who get retire in next 5 years. i tried with lot of queries but didn't get correct output, can you please help in this.

Field Name of Employee Age is "Age in Yrs"

Thank you

[richgalloway]

It would help to see the current query.  Have you tried something like this?

index=foo
| where 'Age in Yrs'>=50