Good summary. I still want to know what happens if I request the number of nanoseconds between Year 0001 and 9999 using datediff. Cos as far as I know datediff won't support a number as big as that.

I've probably got a few more questions that will become evident when I finally get round to digging into this.

-Jamie