Date function in a query

  • Thread starter Thread starter Sarah
  • Start date Start date
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!
 
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
 
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
'====================================================
 
Back
Top