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.

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...eries/201005/1