Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How do we calculate the number of days in a month?
round(monthend(DateField)-monthstart(DateField))
=Day(Monthend(Date Field))-Day(Monthstart(Date Field))
Or even simpler:
day(monthend(DateField))
Hi Anitha,
You can try,
Day(MonthEnd(DateField)) as NoOfDays
- Regards,
Vishal Waghole