DATEDIFF(dd, OpenDate, '20110331') as [Days Open] I need to fix this andget todays day - 100 days.Mathieu Alexandre Cupryk www.omegalove.com ...