EricLynnWright
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
declare @eom datetime
set @eom = DATEADD(day, (0- (datepart(dd,GETDATE())+1) ),getdate( ))
select @eom
set @eom = DATEADD(day, (0- (datepart(dd,GETDATE())+1)
select @eom
ASKER