Thank you very much for the assistance. The code sample you supplied worked great.

-Byron

I am trying to calculate a date range based off the value in my CHAR(6) column.

For example: council_date is defined as CHAR(6). Sample values are 200201, 200202,...