Set Analysis: day()

[mithunr40]

How to calculate the number of employees who was hired on the first day of the month (any month). They give me the  fields and functions to use in set analysis: EMPLOYEE_ID, HIRE_DATE, day()

Please help me out to solve this problem.

Thank you.

[Pavanvh]

Try Below

Count( {<HIRE_DATE={"=Day(HIRE_DATE)=1"}>} EMPLOYEE_ID)

[tresB · Accepted solution]

@Pavanvh you are a quick learner. 🙂 Just 'distinct' is missed - I guess. 

Count(Distinct {<HIRE_DATE={"=Day(HIRE_DATE)=1"}>} EMPLOYEE_ID)

[mithunr40]

Thank you @tresB