Relative Month Calculation

Question

Viewing 5 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Tom257 SSChampion Points: 11543 More actions · Answer 1

SELECT DATEADD(month, -1, GETDATE())

DECLARE @NoPrevious INT

SET @NoPreviou = 13

SELECT DATEADD(month, -@NoPrevious, GETDATE())

Dave Ballantyne SSC-Dedicated Points: 33667 More actions · Answer 2

select datediff(month,getdate(),'01jan2000')

Clear Sky SQL
My Blog[/url]

Jason Coleman SSCrazy Points: 2187 More actions · Answer 3

hmmmm....

simple and effective....where is my brain this morning :blush:

Thx for the code..

Bajrang SSCrazy Points: 2074 More actions · Answer 4

haha.. happens sometimes.. happened to me too...

Happy coding

-RP

-RP

Jason Coleman SSCrazy Points: 2187 More actions · Answer 5

Combine brain failure and working with Oracle in place of SQL Server for the last few months... and bingo!

Forget all the functions and the most simple of methods.. 😛