Last Day of the Month

• KudahX

  Old Hand

  Points: 389

  More actions

  July 26, 2002 at 7:01 am

  #79419

  Given any date, how do you determine the last day of that month, Or how many days that month has?

  I know to do this in VB by using the DateSerial function but not in SQL.

  tnx

• NPeeters

  SSChampion

  Points: 12541

  More actions

  July 26, 2002 at 7:31 am

  #433443

  Following line returns the last day of the current month as a datetime

  DATEADD(day, -1,

  cast(MONTH(DATEADD(month,1,getdate())) as varchar)

  +'/01/'

  + cast(YEAR(DATEADD(month,1,getdate ())) as varchar)

  )

  First you calculate the first day of the next month, then you subtract one day.