Invoice age and excluding valus of 0.00

Question

Viewing 3 posts - 1 through 2 (of 2 total)

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

Ron McCullough SSC Guru Points: 63877 More actions · Answer 1

Look up the DATEDIFF function in Books On Line at:

The GETDATE function reference is:

The following will returrn a value of 3 as today is 10/04/09

.

SELECT DATEDIFF(day, '10/01/09', GETDATE())

Of course you would replace my hard coded 10/01/09 with the value retrieved from your table

SELECT DATEDIFF(Day,yourtable.datecolumn,GETDATE())

For the balance question experiment with:

CREATE TABLE #TT

(Id INT ,Balance MONEY)

INSERT INTO #TT

SELECT 1,$0.00 UNION ALL

SELECT 2,$1.00 UNION ALL

SELECT 3, $-1.00 UNION ALL

SELECT 4,$500.00 UNION ALL

SELECT 5,$.55

SELECT * FROM #TT WHERE (BALANCE BETWEEN -1.00 AND 1) AND BALANCE <> 0.0000

Which will give you:

IdBalance

21.00

3-1.00

50.55

An explanation BETWEEN can be found at:

If everything seems to be going well, you have obviously overlooked something.

Ron

Please help us, help you -before posting a question please read[/url]
Before posting a performance problem please read[/url]

graham.hilton23 Old Hand Points: 393 More actions · Answer 2

Thanks for the reply, I will have a play with these and let you know.

Thanks Agian

Graham