DateAdd from December to January not updating year

I am using DateAdd to determine the dates for worker's review periods from a start date.

This has worked fine all year, but now I have a group that span December to January and the date in January has the correct day, but the year is still 2016.

There are 5 consecutive review periods, this is the code for the first two months, the rest just iterates.
The code looks like this:

Please Login or Register  to view this content.

Is there a way to have DateAdd recognize that the year has rolled over?

Originally Posted by Arkadi

I would guess the problem is that StartPeriod is a string, and perhaps the year is entered as "16" instead of "2016"? working with strings as dates can be messy, and you may be better of converting the string to an actual date variable before using the DateAdd function.

Thanks, it turns out I was looking in the wrong place for the source of my problems - the dateadd was working ok, it was the string output variable's formatting that was causing issues. But I wouldn't have gone down that track without your tip to look at strings vs date.