John

Thanks That worked Great!!

John Spencer wrote:
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

Thanks for the reply

[quoted text clipped - 20 lines]

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