Comparing DOB, resigning and total time assign

[#1]

Hello,

I have Date of Birth of a group of persons also Employed date and for each of the persons can stay a maximum of 35 years if less than 60 years but resigns if equal to 60 years. Hope not confusing?

Note:

• To be able to see all staffs that  have resigned on a separate table or list box.
• To be able to see number of Years/Month/Days a staff has worked so far in the company in the table
• To be able to see number of Years/Month/Days remaining for a staff in the complany in the table

[#2]

Hi Emma,

have a look the 'Age' function to help you with this. Can help you get the age in year of the employee and the time in years they have been employed for.

Age(today(), [DateofBirthField]) AS Employee age

Age(today(), [Employmentdatefield) AS YearInemployment

can then do comparisons on the different ages to demine if they are resigned or not

hope that helps

Joe

[#3]

Joe,

I have done something similar.

[#4]

that should help you then, if you are having a specific problem from there, you might want to post up an example app of the work you have done