>
>Do I understand correctly that DATEDIFF() is a "standard" SQL Function that accepts three parameters? (sorry for so many questions).

It's a function in SQL Server. It allows you to look at the difference between any part of 2 dates. So you can get the minutes elapsed between 2 datetimes, or the days elapsed between 2 dates.

So this...

DATEDIFF( d, '1-1-2014', '1-2-2014')

will return the difference between the first date and the second date, in terms of days.

again, there are all sorts of values for the first parameter...anything from milliseconds to years and things in between.

Never apologize for asking questions. :)