Calculate number of days

[#1]

How do we calculate the number of days in a month?

[Nicole-Smith]

round(monthend(DateField)-monthstart(DateField))

[Anonymous]

=Day(Monthend(Date Field))-Day(Monthstart(Date Field))

[Nicole-Smith · Accepted solution]

Or even simpler:

day(monthend(DateField))

[VishalWaghole]

Hi Anitha,

You can try,

Day(MonthEnd(DateField)) as NoOfDays

- Regards,

Vishal Waghole