Thanks for the reply
I'm getting an error message on the following query.
90days from hire
ateSerial(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