Last day of the month

Returns the last day of the month
Lotus Formula

ACTUAL

month := @Month( @Created ) ;
year := @Year( @Created ) ;
BeginDate := @TextToTime( @Text( month ) + "/01/" + @Text( year ) ) ;
tempenddate:= @Adjust( BeginDate ; 0 ; 1 ; 0 ; 0 ; 0 ; 0 ) ;
@Adjust( tempenddate ; 0 ; 0 ; -1 ; 0 ; 0 ; 0 )

STATIC

MonthNumberIndex := "1" : "2" : "3" : "4" : "5" : "6" : "7" : "8" : "9" : "10" : "11" : "12";
EndOfMonth := "31" : "28" : "31" : "30" : "31" : "30" : "31" : "31" : "30" : "31" : "30" : "31" ;
MonthName := @Replace(MONTHFIELDVALUE; MonthNumberIndex; EndOfMonth);
MonthName

Posted by fbrefere001 on Sunday October 14, 2001