Search results

I am writing a Pension Program for my company. I am extracting the data from our HR system (.dbf) the has the Employee info in one table and the spouse info in an other table. In order to populate or grab the employee we want to run a calculation for I have a pop up box that asks for the SSN...

I have a form with the following expression: NRD: IIf(Left(DateAdd("yyyy",65,[E DOB]),2)="12" And Mid(DateAdd("yyyy",65,[E DOB]),4,2)>16," 01/01/" & Right(DateAdd("yyyy",65,[E DOB]),4)+1,IIf(Mid(DateAdd("yyyy",65,[E DOB]),4,2)<=16,Left(DateAdd("yyyy",65,[E DOB]),2) & "/01/" &...

I hope someone can help me. I need to calculate a Normal Retirement Date. That is the date that you are 65. Also, when calculating this date if you are born <=16 of the month then the date needs to be the first of that month (ex. dob=7/12/57 the NRD would be 7/1/2022) and if you are born...