I need to calulate the end of the month from a character field where first two characters are the month (mm) amd the last two characters are a year (yy). For example 0501 (May 2001) would become 05/31/2001 and 0601 would become 06/30/2001. What is the most efficient way of doing this?