Days in Month calculation

[Lizhin]

In Crystal Reports 8, is there a function or formula that will calculate the number of days in a month if you give it the month, day and year as parameters? Thank you!!

 

[chelseatech]

The easy way is to work out the last day of the month.

numbervar m:= month({table.date}) + 1;
numbervar y:= year({table.date});
datevar lastday;

//Check it's not January in the following year
if m > 12 then (y := y + 1; m := 1);
//Last day of month is...
lastday := Date(y,m,1) -1;

//Days in month is equal to
day(lastday)

 

[jjames]

Day(DateSerial(Year(CurrentDateTime), Month(CurrentDateTime) + 1, 0))