Filtering Retirement Dates - Causing Problem (1 Viewer)

[Brianwarnock]

OK found the problem, Null dates of Birth.
This has never given me this problem before, I would have expected #ERROR from the function.
To overcome this use criteria Is Not Null in the first query Empllist_Current_fqd for DateofBirth.

Brian

 

[PKJ]

Aha. you did miracle for me. Your advice worked perfect with following modification in RetirementDates_sq query -

SELECT A.EmpCode, A.Name, A.Designation, A.OfficeCode, A.DateOfBirth, RetiringDate(DateOfBirth) AS RetDate
FROM EmpList_Current_fqd AS A
WHERE A.DateOfBirth IS NOT NULL;

Dear friend, any thanks would be lesser to express my gratitude for you. Even than loads-of-thanks for this and also telling so many other useful tips.
Regards - PKJ

 

[Brianwarnock]

Glad to have helped, off to enjoy the sun in the garden now.

Brian