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