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