How to show all days number in a month

[alec1982]

Hi,

If i have a

Date field

2010/10/15

2012/5/20

2013/6/18

How can I return the value of all days in the month. like October has 31 days, May has 31 days and June has 30 days

I know Day(DateField) will return the nr of days in the field but I am in a need of the total days of these months.

Thxs for your help.

[#2 · Accepted solution]

Day(MonthEnd(YourDateField)) As DaysInMonth

[alec1982]

Thxs!