Creating date field 1

[jbphoenix]

How would I combine these to make my date field look like this 20090531

select year(dateadd(ms,-3,DATEADD(mm, DATEDIFF(m,0,getdate() )+1,0)))

select month(dateadd(ms,-3,DATEADD(mm, DATEDIFF(m,0,getdate() )+1,0)))

select day(dateadd(ms,-3,DATEADD(mm, DATEDIFF(m,0,getdate() )+1,0)))

 

[gmmastros]

Select DateAdd(Month, 1 + DateDiff(Month, 0, GetDate()), -1)

If you don't want this as a date...

Select Convert(VarChar(8), DateAdd(Month, 1 + DateDiff(Month, 0, GetDate()), -1), 112)



-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[jbphoenix]

That's perfect. Thanks