Month Ending Date

Month Ending Date

Post by Sean Dougla » Sat, 05 Feb 2000 04:00:00



Does any one know an easy way to find the last day of the month?
 
 
 

Month Ending Date

Post by Roy Harv » Sun, 06 Feb 2000 04:00:00


Sean,

Quote:>Does any one know an easy way to find the last day of the month?

SELECT DATEADD(day,-datepart(day,somedate),DATEADD(month,1,somedate))
  FROM whatever

Roy