Date function in a query

S

Sarah

=DATE(YEAR( [Employee Information Master]![Original Hire Date] ),MONTH(
[Employee Information Master]![Original Hire Date] )+4,DAY( [Employee
Information Master]![Original Hire Date] ))

This query returns the error that there the expression has the wrong number
of arguments - please help!
 
C

Conan Kelly

Sarah,

I answed this in your post on ms.public.excel.worksheet.functions, but just
in case, use DATESERIAL in Access, not DATE

HTH,

Conan
 
J

John Spencer

Are you trying to use the DateSerial function?

DateSerial(Year([Original Hire Date])
,Month([Original Hire Date])+4
,Day([Original Hire Date]))

You could also use the DateAdd function to add 4 months
DateAdd("m",4,[Original Hire Date])


'====================================================
John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County
'====================================================
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top