Take a month of days
Declare @datex smalldatetimeset @datex = '2001-1-3' - How many days this month SELECT 32-day (@DATEX 32-day (@datex))
