sql update date to first of next month plus three months : I have this query: 

      update courseRights
             set courseRightsLevelExpires = DATEADD(MM,3,courseRightsLevelExpires)

This works fine but what I actually need is to extend to three months from the first day of next month. For example if the rights are expiring today, May 23rd, I need to update to June 1st + 3 months. 

Is it possible to do that in one query? 

Thanks in advance, Laziale
     