> But this won't work if one had a text column of dates in various > formats, right? Right. In my case I have bad data from a source I didn't control, exported via code that I do control which happens to output YYYY-MM-DD. Well, except that I don't do what I need to when MM or DD are more than 2 digits, but I'm going back to look at that again ;-) -- Scott Ribe scott_ribe@xxxxxxxxxxxxxxx http://www.killerbytes.com/ (303) 722-0567 voice