>>
>>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. :)
Thank you again, very much. I am in a real jam (on vacation in Europe) and a customer came across this problem. So I need to fix it ASAP, via a weak WiFi and other connecting issues.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham