need to get date range from last month to now

[sandeep0000]

im using sql sever, would this work if i want to get sts_dt from last month to now?


pgm.sts_dt >=dateadd(month, datediff(month, 0, getdate()) + 1, 0))

 

[PHV]

Why not asking in an SQL Server forum ?
forum183

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[sandeep0000]

cool thanks for the heads up