• You can truncate the time part and simplify the calculation in one swell foop:

    select DateAdd( m, DateDiff( m, 0, @NextMonth ) + 1, 0 );

    Leave out the "+ 1" and you get the first day of this month.

    Tomm Carr
    --
    Version Normal Form -- http://groups.google.com/group/vrdbms