Jeff, It worked like a charm thanks!

Jenny

I'm trying to write an update command in sql to take the weekyear portion of a serial # and convert it back to a date by extracting the week and...