Link to home
Start Free TrialLog in
Avatar of EricLynnWright
EricLynnWrightFlag for United States of America

asked on

How to i get the last day of the previous month?

How to i get the last day of the previous month?
ASKER CERTIFIED SOLUTION
Avatar of sqlxl
sqlxl
Flag of Canada image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of EricLynnWright

ASKER

Thanks!
Avatar of mvdeveloper
mvdeveloper

declare @eom datetime

set @eom = DATEADD(day, (0- (datepart(dd,GETDATE())+1)),getdate())
select @eom