Need to filter the employees who has joined in current quater

0
Hi, I want to display the list of employees who has joined in the current quater (same year). I have an attribute called Joining Date which stores joining date of employee. Please let me know how to do it in mendix, its urgent   Thanks
asked
2 answers
0

Hi  Trishla T,

                   Check the employees date of joining with current quarter start date?

Date of joining employee >= current quarter.

set the current quarter  date and time in variable.

answered
0

Hi Trishla T ,

Check this condition to find the quarter date

 

if (Month([YourEntity/DateAttribute]) <= 3) then 'Q1'

else if (Month([YourEntity/DateAttribute]) <= 6) then 'Q2' else if (Month([YourEntity/DateAttribute]) <= 9) then 'Q3' else 'Q4'

answered