Drew,

Never mind on this. I just ran a select statement using a convert statement for the datetime and for whatever reason, still got the error. I rewrote this job with some other scripts I previously wrote and was able to get something very similar to what you wrote here on the site.

Anyway, keep up the good work. Your scripts and articles definitely get me going in a direction to improve database processes for my company. Thanks for helping us think outside the box!