General information
Category:
Coding, syntax & commands
>Your formula is a little slower than the other one because it uses GOMONTH twice. It also has 5 function calls vs. 4 in the other one.
>
>But, IMO, it is more readable/clear.
>
>Vlad
>
>>How about GOMONTH( DATE(),1 ) - DAY( GOMONTH( DATE(),1 ) )
>>I guess there's many ways to skin a cat.
Actually, the code I use to get the last date of the month looks like
ldLastDay = GOMONTH( DATE(),1 )
ldLastDay = ldLastDay - DAY( ldLastDay )
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only