Count Before a date

[Afernandes]

Good morning everyone

I have one more question.
I'm trying to count the number of people who have worked in a company for over 3 years. I have a field that is date of admission and the field P_ID(the workers). Strangely I know how to do with specific intervals of time, but I do not know how to do it until 3 years ago.

Thank you very much

[Kashyap_R]

Hi AFernandes,

Use the below expression .

=Sum(If((Today() - [Joined Date.autoCalendar.Date])>1094,1,0))

Hope it works for you,

Thanks,