Formatting a calculated field with DateAdd

[Scott Sabo]

Hello-

I have a query field called EmpHireDate. I want to be able to add a
calculated field that will show the employee hire date plus 6 months.
I can do this with DateAdd but I also need it formatted to return only
the month and day, not the year.

Example: Employee hire date is 02/15/03. I want the calculated field,
Mid Year Review, to display 08/15.

Any help is appreciated as always.

Scott

[Douglas J. Steele]

=Format(DateAdd("m", 6, [EmpHireDate]), "mm/dd")

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(No private e-mails, please)

"Scott Sabo" <ss***@henryschein.com> wrote in message
news:82*************************@posting.google.co m...

Hello-

I have a query field called EmpHireDate. I want to be able to add a
calculated field that will show the employee hire date plus 6 months.
I can do this with DateAdd but I also need it formatted to return only
the month and day, not the year.

Example: Employee hire date is 02/15/03. I want the calculated field,
Mid Year Review, to display 08/15.

Any help is appreciated as always.

Scott