Unanswered: Auto Populate Eligibility date from hire date
I have created a database for employees. I would like the Eligibility date to auto-populate based upon the hire date. For example, if the hire date is 1/19/04, the eligibility date is the first of the month following the hire date ie: 2/1/04. Obviously everyone has a different hire date, but the eligibility date will always be the first of the month following the month they were hired. Now here is the trick. We have a status for each employee. Full Time (FT), Part time (PT) and Temp (TFT). If the status is TFT, the eligibility date should be NULL. I have tried everything I know and need help. Anyone???