calculate first day of next month in following year

[bbbeng]

I have tried to do this using DateAdd but I cant get it to add both the month and year. Sorry if I am missing something obvious.



I have a date field [HireDate] and I need to add one year then get then get the first day of the next month.

For example: HireDate = 1/15/2012 - I need access to return 2/1/2013.

Can anyone make a suggestion regarding how to build that expression? Thanks!

[RuralGuy]

How about DateSerial(Year(HireDate)+1,IIF( Month(HireDate) = 12,1,Month(HireDate)+1,1)

[bbbeng]

Just the tip I needed - thank you!

I used DateSerial(Year([Hire_Date])+1,Month([Hire_Date])+1,1) and it returns just what I needed.

[bbbeng]

oops - you are right , I need to account for the december hire dates.

[RuralGuy]

Glad we could help.