By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,504 Members | 1,583 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,504 IT Pros & Developers. It's quick & easy.

Formatting a calculated field with DateAdd

P: n/a
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
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
=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

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.