• Nigel/Wildh,

    In my original post (768063), I convert the result to style 101 (mm/dd/yyyy), so it doesn't matter if @dt has a time or not.

    DECLARE @dt datetime

    SET @dt = GetDate()

    -- Change to first of the month

    SET @dt = DATEADD(d,1-DAY(@dt),@dt)

    IF DATEPART(dw,@dt) 7

    -- If not already Saturday, add a day until it is Saturday

    WHILE DATEPART(dw, @dt) 7

    SET @dt = DATEADD(d,1,@dt)

    PRINT CONVERT(nvarchar(30), @dt, 101)

    David