Do you need to get the week start and end dates, or the week number in the year? Have you considered the use of a calendar table? Keep in mind that when storing dates as strings, you will likely have to convert back to date to do these types of calculations. It is better to store dates in date format. But I realize you may not have had much choice in the matter.