Date Diff - Tenure
I am looking to build a tenure-based view for a list of employees. I have a hire date field and I want to create a filter to show some categorized options.
Can someone validate if this is possible and any ideas will appreciated
Employees that have 3 weeks of experience ( Something like if datediff today()- HireDate) >21 then 'Employees with three weeks experience' and so on?