Missing a closing parenthesis in the Day(HiredDate) call

DateSerial(Year([HiredDate]), Month([HiredDate])+
IIF(Day([HiredDate])=1,3,4),1)


John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County

Gaetan via AccessMonster.com wrote:
Thanks for the reply

I'm getting an error message on the following query.

90days from hireateSerial(Year([HiredDate]), Month([HiredDate])+IIF(Day(
[HiredDate]=1,3,4),1)

The error message is: The expression you have enterd has a function
containing the wrong
number of arguments.

Any Ideas

Gaetan

John W. Vinson wrote:
I'm trying to figure out hoe to calculate 90 days from hire and the first
of the month
[quoted text clipped - 20 lines]
G
Try

DateSerial(Year([HiredDate]), Month([HiredDate])+IIF(Day([HiredDate]=1,3,4),1)

This will get *three months* which is not necessarily equal to 90 days.