Calculating five days before an employee's birthday...

[P b. Friday]

I posted this question a few days ago:

I am trying to create a queries that tell informs me when

an employee is one year before the retirement age of 62
and another one that notifies me five days before an
employee's date of birth. I assume that I have to use the
DATEDIFF functin. Help!

I have solved the on for the notification prior to the
retirement age. For the five day notification, someone
posted an SQL solution that used the DateSerial function.
Is there a way to write the same expression in Expression
Builder in Access?

P. B Friday
..

 

[John Vinson]

Is there a way to write the same expression in Expression
Builder in Access?

ummm... yes. Use the "Functions" list item on the expression builder
to select the DateSerial function.