? gomonth(date(2001, 5, 1), 1) - 1
>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?
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
