The last date of the month

Archy

How to find the last date of the any month?

jm

Hi,

please have a look at the "CALCDATE" in the C/SIDE-Online-Help.

OR try CALCDATE('<CM>',DateofMonth)

br
Josef Metz

ara3n

Here is how to do it

message(format(CALCDATE('<CY>-11M'))); // 1/31/06
message(format(CALCDATE('<CY>-10M'))); // 2/28/06
message(format(CALCDATE('<CY>-9M'))); //etc etc
message(format(CALCDATE('<CY>-8M')));
message(format(CALCDATE('<CY>-7M')));
message(format(CALCDATE('<CY>-6M')));
message(format(CALCDATE('<CY>-5M')));
message(format(CALCDATE('<CY>-4M')));
message(format(CALCDATE('<CY>-3M')));
message(format(CALCDATE('<CY>-2M')));
message(format(CALCDATE('<CY>-1M')));
message(format(CALCDATE('<CY>')));