Discussion Board for collaboration on QlikView Scripting.
How do we calculate the number of days in a month?
Go to Solution.
Or even simpler:
=Day(Monthend(Date Field))-Day(Monthstart(Date Field))
You can try,
Day(MonthEnd(DateField)) as NoOfDays