Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2003
    Posts
    3

    Red face 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???

  2. #2
    Join Date
    Oct 2001
    Location
    Chicago
    Posts
    440
    Eligibility Date: IIf([Status]="TFT",Null,DateSerial(Year([HireDate]),1+Month([HireDate]),1))

    Cheers - Matt

  3. #3
    Join Date
    Sep 2003
    Posts
    3
    That is AWESOME!!!!! Exactly what I was looking for. I haven't tried it, but it coincides with everything I have been trying, so I am it will work perfectly!

    Originally posted by Rockey
    Eligibility Date: IIf([Status]="TFT",Null,DateSerial(Year([HireDate]),1+Month([HireDate]),1))

    Cheers - Matt

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •