Got this


Code:
IIf(Format([EndDate],"mmdd")="0630",[EndDate],DateSerial(Year(DateAdd("m",6,[StartDate])),6,30))
and seems to be working as needed