Thanks for the excellent reply and the links, I'll have to dig into them a bit later this week.

Never really thought about using the dateadd/datediff functionality to get to dates prior to 1900 as I've always been asked to support last week, last quarter type of information. Good to know to look out for it on older dates though.

-Luke.