>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?
Look up "Some useful date functions" in the UT FAQ. It gives functions for many date manipulations.
Bill
William A. Caton III
Software Engineer
MAXIMUS
Atlanta, Ga.