ChangeDateTpFirstOfNextMonth

• Kristy

  SSC Enthusiast

  Points: 167

  More actions

  August 7, 2008 at 9:02 am

  #195614

  Comments posted to this topic are about the item ChangeDateTpFirstOfNextMonth

• wildh

  SSCarpal Tunnel

  Points: 4370

  More actions

  August 14, 2008 at 1:33 am

  #857862

  If your want to remove the time portion of the result you could use this - select dateadd(month,datediff(month,-1,getdate()),0)

• rgillings

  SSCrazy

  Points: 2114

  More actions

  August 14, 2008 at 5:12 am

  #857956

  Alternately, you can also use the DATEPART function instead of DATEDIFF:

  DECLARE @Date DATETIME

  SET @Date = GETDATE()

  SELECT DATEADD(MONTH,1,DATEADD(DAY, (-1 * DATEPART(DAY,@Date)) + 1, @Date))

• Tomm Carr

  SSCertifiable

  Points: 5426

  More actions

  August 14, 2008 at 11:38 am

  #858273

  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