sql server reporting services: Difference in 2 dates -- sql server reporting services

Difference in 2 dates

Bunckles
6/1/2005 10:50:14 AM

sql server reporting services:

I am creating a report that shows customer payment trends.

The report uses an oracle table that has a DATE column and a TRANS_TYPE
column. DATE contains the date of the transaction, TRANS_TYPE contains
'IN' for invoice or 'PY' for payment.

The report user will enter a customer number and a date range to see
how long the customer takes to pay their bills.

How can I find the differnce in the dates when the two dates are in the
same field?

Re: Difference in 2 dates

Wayne Snyder
6/1/2005 6:01:07 PM

Answered in the other post, Bunkles...

hope it helps.

--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)

I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org

[quoted text, click to view]