Find Start of a Month for Given Date

Finds Start of the month with given date

CREATE  FUNCTION [dbo].[StartOfMonth]
(
  @date datetime
)

RETURNS datetime
AS
BEGIN
  return DATEADD(M,-1,DATEADD(mm, DATEDIFF(m,0,@date)+1,0))
END