Jeff Moden (12/4/2012)
Then substitute a 0 for Michael's -53690. 😀That, not withstanding, it's always the "edge cases" that cause panic stricken calls at 3 in the morning.
If I have to worry about dates that far back, I'll convert everything to datetme2 since this is a SQL Server 2008 forum. That way I can go back further. Only problem then is what calendar do you really use? Heck, if I remember correctly we used different calendars into the early 1900's didn't we?