Aging date - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

Aging date

Author

Topic

noks
Starting Member

9 Posts

Posted - 2010-11-23 : 10:36:47

Hi

Can you please assist with getting the amounts for aging dates (30, 60, 90, 120 etc) dates
I'm trying to get it for the past 12 months from previous month. Since it's currenty Nov it wold have to be from Nov 2009 - Oct 2010

Thanks

elwoos
Master Smack Fu Yak Hacker

2052 Posts

Posted - 2010-11-23 : 11:33:13

I don't understand the question. Please check this link http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

-----------

I used to think I wasn't a morning person but it never got better in the afternoon

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2010-11-24 : 09:42:04

are you asking for monthly amounts?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2010-11-26 : 03:02:21

Hint

--30 days old

where datecol>=dateadd(day,-30,getdate())

Madhivanan

Failing to plan is Planning to fail

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources