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

  • Thread starter Thread starter P b. Friday
  • Start date Start date
P

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!
Click to expand...

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
..
 
Is there a way to write the same expression in Expression
Builder in Access?
Click to expand...

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