Hi Team,
I have a list of employees, when marked their DateOfExit they are now non-active employees.
I have an allocation option, where I allocate the employees to the project for each month. Hence while adding a new allocation for an employee, the employee list should display employees who are all active and employees marked resigned for the current month.
Meaning, that suppose say we have two employees name A and B, A's resignation date is 14 Sep 2022 and B's resignation date is 3 Oct 2022.
Now the list of employees should show while adding for an allocation, it should display only B. Because B's resignation is current month and A is on previous month.
I display month in a dropdown named - DropMonth and Items are ["Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec"],
the default will be - Text(Today(),"mmm")
Thank you for your help.
Thanks,
Harisha