Skip to Content
0
Former Member
Jun 10, 2009 at 11:19 AM

Calculating the Number of Days between today and creation date.

43 Views

Hi Experts

I'm looking to include a calculated field in a report which shows the number of days between the Date an Opportunity is created (Open Date) and Today's date. As a novice in SQL queries, i've tried below but it does not work!

SUM(DATEDIFF(DAY,GETDATE () - T0.[OpenDate])

Can anyone tell me where I am going wrong?

Thanks

Derek