Thanks.
I have an EMPLOYEE table with DateOfHire and LenghofService (LOS) among the fields. The LOS value should be derived based on the hired date and the current/sysdate.
Once again, thanks for your help!
Expe
Thanks, Ranman256 - The function dateDiff("d",[HireDate],Date()) works except that I get an error message when I try to use it in a Calculated Field with the message that it cannot be used in a calculated field. Any advice?
Expe
I need help using a function or query to calculate length of service based on employee hire date (table column) and current/today's date. I will appreciate your assistance.
Thank you in advance!
Expe