month to date

[sonny1974]

i have sql server and crystal xi

i am going to automate a report

"BI_DTL"."BEN_BGN_DT">= dateadd(day, 14,
dateadd(month, datediff(month, 0, getdate()), 0)
)

how do i change this to month to date
so if the report is ran on may 25th it would be may 1st to may 25th

 

[SQLDenis]

>= dateadd(month, datediff(month, 0, getdate()), 0)

Denis The SQL Menace
--------------------
SQL Server Code,Tips and Tricks, Performance Tuning
Google Interview Questions

 

[sonny1974]

thanks