Hi again, Mike!

I thought that this thread was done ... but I guess not.

There seems to be some diversity of opinion about whether even your "last day of month" code should be left as is or encapsulated into a sub-routine.

That was essentially my point from before -- there are different perceptions of the degree of complexity needed before one thinks it necessary to use a sub-routine. Some of this has to do with the idioms of the language, I think, and more experienced users have a wider list of idioms that they recognize without having to think about it.

My opinion is that any newbie would love to have that line of code hidden within a well-named PRG.

Cheers,

Jim

>>>All the more reason to have it, IMO. What do you think this means: GOMONTH(DATE() - DAY(DATE()) + 1, 1) - 1
>>>
>>>A rose by any other name would smell as sweet, but having to decipher a formula stinks.
>>>
>>
>>It means last day of this month. What is there to decipher it? To decipher you need something like a cipher, no? Maybe I don't see the philosophy here:) IMHO that X2... was something to decipher for a simple task that you could do inline.
>>Cetin
>
>I'm surprised you do not see the problem. GetLastDayOfMonth() needs no deciphering/decoding/thought. If you have never seen the above line, you cannot tell what it does as quickly as GetLastDayOfMonth().